No video

Supercharge Your Power Apps with Direct Graph API Integration 🚀

  Рет қаралды 56,101

Reza Dorrani

Reza Dorrani

Күн бұрын

Пікірлер: 323
@nomandanishshaikh9174
@nomandanishshaikh9174 Жыл бұрын
I wanted to take a moment to express my heartfelt gratitude for the incredible videos you create. Your content has been a constant source of inspiration and knowledge for me. I have learned so much from your videos. Your dedication to creating original and insightful content is truly commendable. The way you present complex concepts in a relatable and understandable manner is remarkable. Your videos have not only expanded my knowledge but also ignited my curiosity to explore new subjects and ideas. Thank you for sharing your expertise and creativity through your videos. Your contributions have made a significant difference in my life, and I'm certain I'm not alone in feeling this way. Please keep doing what you do best and continue inspiring others with your remarkable content.
@RezaDorrani
@RezaDorrani Жыл бұрын
Thank You so much Noman for your kind words 🙏 Appreciate the ❤️ and support. I will keep trying my best to provide unique and quality content.
@chap666ish
@chap666ish Ай бұрын
Reza, you have no idea how amazingly helpful this video has been. I can now directly solve two tricky challenges from my business users as a result of learning how to use Graph API from PowerApps! Thank YOU!
@RezaDorrani
@RezaDorrani Ай бұрын
Fantastic! Thanks so much for watching and learning from the videos
@dougydoe
@dougydoe Жыл бұрын
What makes your videos stand out is not just the quality of the content but more especially, the style of delivery which helps me to understand the concept properly. I've always wanted to delve more into working the Graph API a but more but haven't been able to...... until NOW. Thanks to your video. As always, I would have to watch this a number of times to really get it and try it out. Really admire your commitment to knowledge transfer and long may it continue. Appreciated.
@RezaDorrani
@RezaDorrani Жыл бұрын
Thank You so much for appreciation and the feedback. You are most welcome and I hope to continue as long as I can.
@WillCooper1
@WillCooper1 Жыл бұрын
I have been getting more and more interested in the SharePoint HTTP Request in Power Automate. We can make a GET request and use the Parse JSON action to access attributes. It's very exciting learning how to be able to access many granular properties that otherwise aren't easily accessible. Thanks for shining a light on this exciting new functionality in Power Apps. Love your content.
@RezaDorrani
@RezaDorrani Жыл бұрын
Awesome!
@chriswebbtech
@chriswebbtech 11 ай бұрын
This is game changer. I was just trying to figure this out today and turning on that JSON preview feature was what I was missing. Pretty powerful stuff.
@RezaDorrani
@RezaDorrani 11 ай бұрын
It sure is a game changer
@DaniilStanisevschi
@DaniilStanisevschi Жыл бұрын
Reza, this is worth it's weight in gold and more. Amazing content and walk through sir. Graph API is going to change and allow for so much more as presented by you. I can only imagine the possibilities as we get more endpoints and more nest tricks to hopefully reach Dateverse level delegation in SharePoint.
@RezaDorrani
@RezaDorrani Жыл бұрын
There is a lot more to uncover. I have a series of ideas in the works.
@saeedsm57
@saeedsm57 Жыл бұрын
Definitely a supercharged training video has been added to your superb Power Platform training collection! Thanks Reza!
@RezaDorrani
@RezaDorrani Жыл бұрын
More to come!
@akshaynm
@akshaynm Жыл бұрын
Indeed a Game Changer... I think, words are insufficient to thank you for showing this great functionality. 😊🙏🏻
@RezaDorrani
@RezaDorrani Жыл бұрын
Wow! Thank You so much
@yoginathbadadale
@yoginathbadadale Жыл бұрын
Thank you very much Reza i am glad that i am part of this channel as usual you are the best 🙏🙏🙏🙏🙏
@RezaDorrani
@RezaDorrani Жыл бұрын
Thank You for being a part of the channel
@isaiaguillon9878
@isaiaguillon9878 Жыл бұрын
Wow!!!! Cant's wait for the search in the entire library video. Thank you Reza
@RezaDorrani
@RezaDorrani Жыл бұрын
More to come!
@aescamilla
@aescamilla Жыл бұрын
Amazing!!! can't wait for the "search file" video to come out... thank you Reza!
@RezaDorrani
@RezaDorrani Жыл бұрын
Search lists will come first.
@oluwatobipaul6171
@oluwatobipaul6171 Жыл бұрын
This is a whole new level with Graph API. Thanks a lot Reza
@RezaDorrani
@RezaDorrani Жыл бұрын
Thank You
@patelbhargav
@patelbhargav Жыл бұрын
Reza, you left me wanting more with the sneak peak. Now I want to fast forward the time to release of the next video. 😂
@RezaDorrani
@RezaDorrani Жыл бұрын
I have so many ideas with this technique. I will open the book one page at a time :)
@patelbhargav
@patelbhargav Жыл бұрын
👏🏼 Super excited for the series 🥳
@rkirk2k
@rkirk2k Жыл бұрын
Thank you again Reza, for your generous sharing of your knowledge, time and efforts. You're becoming a virtual mentor in my career, and I am grateful sir.
@RezaDorrani
@RezaDorrani Жыл бұрын
Wow, thank you so much!
@rkirk2k
@rkirk2k Жыл бұрын
@@RezaDorrani I can't wait to see how you pass the text input value as a file for the SEARCH function.
@RezaDorrani
@RezaDorrani Жыл бұрын
@@rkirk2k I will be showcasing an early preview to Channel Members during the Office Hours session this Saturday. Check community tab on my channel for details.
@bernardnguyen5382
@bernardnguyen5382 Жыл бұрын
Thanks you Reza for sharing ! this is crazy ! exited to see your nexts videos about the subject ! ✅🔥
@RezaDorrani
@RezaDorrani Жыл бұрын
More to come!
@svesamm
@svesamm Жыл бұрын
aaah .. you stopped at a very interesting part just like TV show 😄. Many thanks for this amazing video Reza and for sharing 👍
@RezaDorrani
@RezaDorrani Жыл бұрын
Until the next episode 😊
@azzazzin08
@azzazzin08 Жыл бұрын
You are the man! Thank you so much for all your videos and contribution on helping us pave the way forward!
@RezaDorrani
@RezaDorrani Жыл бұрын
My pleasure!
@bazzgaming1955
@bazzgaming1955 Жыл бұрын
Wow awesome, this opens up so much possibility to work around with Power Apps. Thank you wo much for this valuable information. You rock!!
@RezaDorrani
@RezaDorrani Жыл бұрын
You're very welcome!
@mspowerassist
@mspowerassist Жыл бұрын
Thank you @Reza for bringing up the useful content as usual.
@RezaDorrani
@RezaDorrani Жыл бұрын
Most welcome
@AnoopKumar-qx8to
@AnoopKumar-qx8to Жыл бұрын
Thank You Reza Sir. It will help resolve complex use cases. Powerapps showing next level capabilities now🤗🤗
@RezaDorrani
@RezaDorrani Жыл бұрын
Yes it will
@ambarish360
@ambarish360 Жыл бұрын
Thanks a lot to you @Reza and Hiro, for letting us know, I've been using this graph api and do the alter using VS Code from one of the video from Deepak Srivastava.
@ambarish360
@ambarish360 Жыл бұрын
Eagerly waiting for the Video on Post method for search in Large data set on SP.
@RezaDorrani
@RezaDorrani Жыл бұрын
This is all Hiro’s find. He is the hero.
@ambarish360
@ambarish360 3 ай бұрын
​@@RezaDorrani now in 2024, they've (Microsoft) has deprecated this connector and introduced v2 of it but it is restricted to sub group /groups, any work around for it??
@RezaDorrani
@RezaDorrani 3 ай бұрын
@@ambarish360 Check my follow up videos to this.
@ambarish360
@ambarish360 3 ай бұрын
@@RezaDorrani thanks a lot, that's what (http req to Azure AD in power automate) is what I'm using now. One more thing I noticed, i don't have the premium licence but still some connectors like http, this send http req to Azure AD does work. Is it labeled as premium and could work as standard connector?
@royfocker19
@royfocker19 7 ай бұрын
It's incredible there is so little documentation about how to do calls to azure devops and show System.History. With this video I was able to solve it. Thanks Reza
@RezaDorrani
@RezaDorrani 7 ай бұрын
Glad it was helpful!
@hsaxena502
@hsaxena502 Жыл бұрын
Thanks for sharing it. Not sure if you remember that i had requested for this video. Now this will make my life easy. BTW i am building an app using this technique which will show all sites owned by a user and user will be able to manage his/ her own site.
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks for the idea!
@felixverduin569
@felixverduin569 Жыл бұрын
I like this advanced topic! Very nice Reza.
@RezaDorrani
@RezaDorrani Жыл бұрын
Glad you liked it!
@stevec8781
@stevec8781 Жыл бұрын
Good stuff, Reza! Love the content.
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks Steve
@mdhidayat5706
@mdhidayat5706 Жыл бұрын
wow, amazing possibility, I can integrate this with approvals workflow. thank you for sharing!
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks. Can you share your idea about using it with approvals?
@ZackMatos
@ZackMatos Жыл бұрын
I would love to see more videos exploring the Graph. Use api to edit an item or file etc. I can learn best from examples. These contents are extremely scarce.
@RezaDorrani
@RezaDorrani Жыл бұрын
Noted! I have 5-6 ideas lined up
@SHAli1474
@SHAli1474 Жыл бұрын
As always very informative and to the point. Thanks Reza
@RezaDorrani
@RezaDorrani Жыл бұрын
My pleasure!
@JackCastro
@JackCastro Жыл бұрын
This is awesome Reza! Thank you!
@RezaDorrani
@RezaDorrani Жыл бұрын
Most welcome
@jatinsaini7773
@jatinsaini7773 Жыл бұрын
Hi @Reza, Great Content! Loved Your way of explanation simplicity and knowledge. I was hoping when we could expect detailed video on how to work with the power automate connector - SERVICE NOW and how we could integrate it within PowerApps. Using the API or any other method if possible
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks! I have no plans for any videos on service now. I ask subscribers for topic suggestions on Community Tab of my channel every quarter. Most voted ideas get added to my backlog. No one has asked for a video on these lines. May be try posting this in the next topi suggestion post and if it gets max votes, I would add it to my backlog
@anantchirmade600
@anantchirmade600 Жыл бұрын
Shoutout to Hiro and Reza for this Great breakthrough!
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks Anant. A lot more to come!
@crullmar
@crullmar 10 ай бұрын
Love this. My cat watched it to. Wish I could post video here.
@RezaDorrani
@RezaDorrani 10 ай бұрын
:) You can post it on linkedin or X and tag me
@crullmar
@crullmar 10 ай бұрын
I tagged you on tictok video I just uploaded
@RezaDorrani
@RezaDorrani 10 ай бұрын
@@crullmar Im no longer active on tictok
@eyoborelvis8224
@eyoborelvis8224 Жыл бұрын
Thanks Reza, You're the best
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks so much
@benjaminjones5544
@benjaminjones5544 Жыл бұрын
Superb Reza... Also, this was the first time i have seen the function Table. I'm going to try and use this function to replace my method, when I store a sub table in html format within a sharepoint list. When i load it back in powerapps as a gallery i have to split on and then use mid and find functions to get the individual details. Also just thinking have you ever collected a table of data and posted it as Json into a multi line of text in a sharepoint list item and then pulled it back into power apps into a gallery?
@RezaDorrani
@RezaDorrani Жыл бұрын
I have not posted table of data as json in multi line text field. This resembles a repeating table kind of a scenario.
@paolovr1970
@paolovr1970 Жыл бұрын
Amazing Reza thanks 🙏🙏🙏
@RezaDorrani
@RezaDorrani Жыл бұрын
Welcome!
@TheEpiCool
@TheEpiCool Жыл бұрын
This is HUGE!
@RezaDorrani
@RezaDorrani Жыл бұрын
As long as http action supports it :) Next video I plan to show 2 ways of achieving something new with graph api.
@nkidd3358
@nkidd3358 6 ай бұрын
Hello Reza. This video was fantastic, thank you! I see you replied to another comment, saying you have done a series of videos for Graph, however this is the only one I can find. Can you point me to the other videos? Thanks!
@RezaDorrani
@RezaDorrani 6 ай бұрын
Check videos on or around the same time frame.
@beccad3296
@beccad3296 Жыл бұрын
Great and very timely video Reza as I was just working on some Graph API stuff with a colleague. I am very interested in that last part you mentioned about being able to search a list or document library with Power Apps and the Graph API. Do you have a rough timeline on when that video will come out?
@RezaDorrani
@RezaDorrani Жыл бұрын
Rought timeline is within the next 2-3 weeks. I have 4-5 video ideas lined up with the graph API approach.
@davidmashworth
@davidmashworth 5 ай бұрын
Thanks Reza, this is great. I am wondering if you have tried updating a group using a POST function? The problem I am facing is an emtpy JSON payload.
@RezaDorrani
@RezaDorrani 5 ай бұрын
I dont think I tried post with JSON payload hence not sure
@mrvasu230485
@mrvasu230485 Жыл бұрын
Great video
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks!
@basehumax
@basehumax Жыл бұрын
Hi Reza, Thanks, is it possible with Graph to get comments field version history ?
@RezaDorrani
@RezaDorrani Жыл бұрын
I am not sure. You would need to check the Graph API documentation.
@virzaniarimanalu7221
@virzaniarimanalu7221 Жыл бұрын
Amazing video Reza, I really like your video. You explain everything like it looks so easy. But I want to ask 1 thing, is this Microsoft graph api free for Office365 E1? or there are limitations in using this service? Thanks before
@RezaDorrani
@RezaDorrani Жыл бұрын
The graph api is available for all licenses (as far as I know). When calling Graph from power apps or automate, the license depends upon which connector we use.
@Cielu1
@Cielu1 Жыл бұрын
Nice, finally overcome limitations of 365 users connections. Looks like more API could work then ?
@RezaDorrani
@RezaDorrani Жыл бұрын
The API endpoints supported are listed in video.
@esbenk.d.jensen9345
@esbenk.d.jensen9345 Жыл бұрын
Interesting, very similar to a solution I’m working on for power automate using http request to get files modified on or after a selected date.
@RezaDorrani
@RezaDorrani Жыл бұрын
Yes, this is all in Power Apps though.
@bridgetdixon8272
@bridgetdixon8272 9 ай бұрын
Great video! However I don’t see that option to turn on parsejson….
@RezaDorrani
@RezaDorrani 9 ай бұрын
ParseJSON is GA now so no need to turn it on
@rameshc4498
@rameshc4498 Жыл бұрын
Great..
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks
@jandjtempleton
@jandjtempleton Жыл бұрын
Hi Reza, Great video as always! I have an existing app which when I try to use the Graph API it is still showing as a boolean value not an Untyped Object ? I have updated the app settings with the parseJSON preview feature but still no luck? Any ideas on what might be happening or is this a limitation? I have tried in a new blank app and worked fine.
@RezaDorrani
@RezaDorrani Жыл бұрын
Turn off untyped objects feature, publish app, close app. Edit app, turn on features, publish app, close app. Edit app and test. This worked for me.
@jandjtempleton
@jandjtempleton Жыл бұрын
@@RezaDorrani Perfect thank you very much!
@matlionis6110
@matlionis6110 Жыл бұрын
Awesome stuff Reza, I tried to get the presence of the user in teams but this seems not to work as I get the error message that it is forbbiden. Is this on MS side or mine is at this point unknown. Do you perhaps know more?
@RezaDorrani
@RezaDorrani Жыл бұрын
Not all actions are suppressed in the endpoints mentioned. Only delegable permissions are supported. I did try presence (I was planning a demo on it), that does not work due to the permissions it needs in Graph and the Office365Groups http action does not support it.
@matlionis6110
@matlionis6110 Жыл бұрын
@@RezaDorrani I figured that out, hopefully it will be implemented soon without the "special key"
@RezaDorrani
@RezaDorrani Жыл бұрын
Not sure if there are any plans for that
@matlionis6110
@matlionis6110 Жыл бұрын
one can always hope there is :)
@holgertangemann4813
@holgertangemann4813 Жыл бұрын
Hey Reza, that looks really great thank you very much. I’m a big fan of your videos and it helped me al lot. One question - how to upload and download large files. I know you made a video on small files with graphapi but I try handling large files >100MB with PowerApps but it always comes to issues - I think in case of the loading times. Is there a possibility to handle large files?
@RezaDorrani
@RezaDorrani Жыл бұрын
There is a possibility for large file upload as there is an API for it. Would need more investigation from my side. I dont plan to do that anytime soon.
@avinoamrothenberg1244
@avinoamrothenberg1244 Жыл бұрын
This video is definitely one of THE best... But, as per the method of uploading a file to SP via Graph API - isn't there a limit of file size to 4MB ?
@RezaDorrani
@RezaDorrani Жыл бұрын
Its 4 MB but there us an API for larger files as well. I am exploring it.
@ajking7905
@ajking7905 Жыл бұрын
awesome videos! can you also show how to search the gallery that is using the graph API to pull in user date?
@RezaDorrani
@RezaDorrani Жыл бұрын
I have a search video planned that would be my next video. Searching on dates is not a good option. You would rather want user filtering on dates or date ranges. I have done many videos on it. Here is one for reference kzfaq.info/get/bejne/mNuae5WY37rIpYU.html
@mattschaffer147
@mattschaffer147 Жыл бұрын
Reza - you got anything for creating the JSON body of a PATCH/PUT/POST request dynamically for one of these HTTP requests since the input for the body is of type "file"? I found I could base64-encode the body (just as a text string in JSON formatting) then put that as an image property of an image control using a data URI (like making an SVG image from XML text or reversing the "get binary content from an image using the JSON() function) and then pass that Image.Image through as my "file" for the body of the request. Allows me to create/update meeting invites, add owners to a group, create a group, subscribe somebody to a group's emails, etc.
@RezaDorrani
@RezaDorrani Жыл бұрын
I will be doing something similar. The search part I did a demo of in end of video, uses that concept.
@christiangogreen4567
@christiangogreen4567 Жыл бұрын
@@RezaDorrani Your video came - as usual - exactly in time as I was trying to avoid Power Automate and Premium Connectors. The cliffhanger at the end left me exactly where I am stuck now. I'm trying to figure out how to do this, but i can't make it work. I try to create a draft mail from a few parameters in a Canvas App and Post it with the Graph API to the Messages endpoint. All get requests work pretty fine, I just can't figure out the mentioned workaround from Hiro's blog, your video and mattschaffer147's post to make the request body for a post work.
@RezaDorrani
@RezaDorrani Жыл бұрын
@@christiangogreen4567 My video will mostly go live tomorrow. Channel members already have access to it. Silver members get access to code base (app/flow) as well. In case you would like to join, here is the link kzfaq.infojoin
@kamakshishah2122
@kamakshishah2122 9 ай бұрын
Thanks for sharing. I have one query. How can we get businessPhones of the user in a collection.
@RezaDorrani
@RezaDorrani 9 ай бұрын
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@StianHoel
@StianHoel Жыл бұрын
Great video, Reza! Did you figure out if this can be enabled for "old" apps? Also, what is the update where the change from Boolean to untyped object was made?
@RezaDorrani
@RezaDorrani Жыл бұрын
Yes I did. Disable feature in old app -> Publish App - > Close App -> Edit App -> Enable feature -> Publish App -> Close App -> Edit App and it should work.
@Learnpowerplatform
@Learnpowerplatform Жыл бұрын
@@RezaDorrani i performed these steps
@RezaDorrani
@RezaDorrani Жыл бұрын
@@Learnpowerplatform Remove and add the Office365Groups connection. It will work.
@Learnpowerplatform
@Learnpowerplatform Жыл бұрын
@@RezaDorrani I will try it. Thanks for giving quick response from your busy schedule
@yonasyohannes9076
@yonasyohannes9076 Жыл бұрын
I would appreciate if you have serious of videos on a project that includes graph API and power platform including power BI. Staring from basics.
@RezaDorrani
@RezaDorrani Жыл бұрын
I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on community tab. Most voted ideas get added to my backlog. Make sure to post this idea whenever the next topic suggestion post is out.
@bgergoe
@bgergoe Жыл бұрын
Thank you for this video, this is very useful. Do you by any chance know how to manually write the body part of PUT/POST API calls (for example add a new owner to an Office 365 Group) in PowerApps?
@RezaDorrani
@RezaDorrani Жыл бұрын
I have done other videos on graph which showcase post api. Check my playlist.
@bgergoe
@bgergoe Жыл бұрын
@@RezaDorrani found it in the 'Search SharePoint Lists without Delegation Issues' video's 'How to call Microsoft Search API from Power Apps?' section, and it works, thank you so much! :)
@jimpowers7603
@jimpowers7603 Жыл бұрын
Hi Reza. I just noticed on Microsoft's documentation that they deprecated this action, and the v2 action only support one endpoint. Do you have a sense of how long it takes for a deprecated item to be taken out of service.
@RezaDorrani
@RezaDorrani Жыл бұрын
I am not aware of the timeline. Existing apps using the endpoint would continue to function. New Apps would not get that endpoint.
@user-xh2cn5qk8c
@user-xh2cn5qk8c 11 ай бұрын
Can you point me to that change at the MS site ?
@RezaDorrani
@RezaDorrani 11 ай бұрын
@@user-xh2cn5qk8c aka.ms/connectors - search for the office 365 groups connector
@Learnpowerplatform
@Learnpowerplatform Жыл бұрын
Very good video. Thanks Reza. For me after turning on untyped object settings also variable values remain true or false. Could you please suggest why this is happening
@RezaDorrani
@RezaDorrani Жыл бұрын
Check video comments.
@Learnpowerplatform
@Learnpowerplatform Жыл бұрын
@@RezaDorrani yes. I tried that but it did not work for me in existing app. But it is working for new app. Thanks
@RezaDorrani
@RezaDorrani Жыл бұрын
@@Learnpowerplatform What were the steps? Did you delete and add the O365Groups connection again?
@Timmones
@Timmones Жыл бұрын
Incredible tutorial, Reza. I'm having an issue with the "ParseJSON function and untyped objects" upcoming feature, though. It's still returning a boolean into the global variable I'm saving the response to, despite having the new feature enabled. However, when I check the Monitor, the response tab on the request shows the JSON and table successfully from the request. edit: On a hunch, I created a new blank app and tested the same HttpRequest in the new app and it actually returned an UntypedObject in that one, instead of a boolean. Is it not possible to turn this feature on for an app that has existed for a while?
@skateparkpechu
@skateparkpechu Жыл бұрын
I have the same issue.
@RezaDorrani
@RezaDorrani Жыл бұрын
I believe this might be a bug where it works in new apps only. I would have to investigate and see if there is a way to enable this for old apps.
@mattschaffer147
@mattschaffer147 Жыл бұрын
When you turn on the feature, you need to save the app, then close and reload it in order for the feature to actually take effect (in apps that existed prior to the feature existing). New apps have it on by default and should just work OOTB.
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks for sharing
@Timmones
@Timmones Жыл бұрын
@@mattschaffer147 You’re right about needing to save it and then refresh the app. The Microsoft prompt states that when you enable the feature. When I relaunched the app afterwards, it displays that the feature is enabled, but the API calls still return a Boolean. This is the case with all my older apps. All of the apps that I have created after the update return UntypedObjects, as expected. As Reza suggested, I believe this to just be a bug.
@brendanbowen7097
@brendanbowen7097 Жыл бұрын
Hm, this is quite promising! I was wondering if we could use method to lookup a member of a specific 365 group (the current user of the app) and leverage that response (blank or not) in a permissions/role based access scenario within the app. I've never cared for the list group members action to then filter it to find a specific member and determine it's access and maintaining users in a sperate SharePoint list has always seemed clunky
@RezaDorrani
@RezaDorrani Жыл бұрын
Possible as long as graph has the option. I believe it does. Check the documentation to see which endpoint will help with this.
@mattschaffer147
@mattschaffer147 Жыл бұрын
/me/memberOf would show all 365 groups the current user is a member of - you could filter that to look for the specific group you want
@RD-gp1mu
@RD-gp1mu Ай бұрын
Thank you @RezaDorrani! Really helpful. Is it possible to search a particular AD group for users, choose a specific user, enable their account, allow the 'logged in admin user' to generate a random passphrase from a table of values and reset their password? Caveat: these accounts to be re-enabled etc were created in local AD, not in Azure Entra but using AD connector, there is a synch every 10-30mins. Can i still use MS Graph API? I think the admin user needs to be allowed to reset and re-enable the user account. I think rights permissions to AD and Entra? Not sure how to do this, any advice would be great.
@RezaDorrani
@RezaDorrani Ай бұрын
I am not sure of the possibilities here. Search ad user, reset password etc possible but not sure with local AD.
@Emanuel-fu4cf
@Emanuel-fu4cf Жыл бұрын
When posting files to libraries is it possible to set metadata for them? and/or capture the file id after it was upladed? Thanks by the way I'm currently exploring Graph features and this is amazing conten!!! (as always) 👌👌
@RezaDorrani
@RezaDorrani Жыл бұрын
The api to upload files requires that first the file is uploaded and only then can you update its metadata. It would be a 2 step process.
@Emanuel-fu4cf
@Emanuel-fu4cf Жыл бұрын
@@RezaDorrani thank you! looking forward for the next video on this series
@arsenio333aa
@arsenio333aa 25 күн бұрын
Reza, could you make a video about "how to create an UPLOAD SESSION" in order to upload file (>250Mb) to Sharepoint?
@RezaDorrani
@RezaDorrani 25 күн бұрын
I would first have to learn how to do that with power apps.
@Serioustroop
@Serioustroop Жыл бұрын
GET Video😊 but I would want an API call to something that is outside SharePoint or MS
@RezaDorrani
@RezaDorrani Жыл бұрын
For that you can use custom connectors.
@Serioustroop
@Serioustroop Жыл бұрын
@@RezaDorrani thank you for responding. I’m gonna have to explore the custom connector. I believe this is a premium service.
@RezaDorrani
@RezaDorrani Жыл бұрын
@@Serioustroop Yes, custom connectors are premium
@cnchandroo
@cnchandroo 5 ай бұрын
Thanks Reza for this video. It is quite interesting and very informative. However, based on the MS documentation, this HttpRequest from Office 365 Groups was deprecated, instead use HttpRequestV2. Also, in V2, only Groups endpoint is allowed, not all the graph endpoint. Is it still valid to use V1, which gives this feature.
@RezaDorrani
@RezaDorrani 5 ай бұрын
Even in v1 not all endpoints were allowed. V2 is now only for groups. There is separate ones for groups, outlook and onedrive. SharePoint we can use http action and call hidden apis under graph. I did 3-4 videos around this timeframe where I have shown multiple options.
@cnchandroo
@cnchandroo 5 ай бұрын
Thanks @@RezaDorrani for your swift response.
@muhammadhassan1843
@muhammadhassan1843 11 ай бұрын
Hey Reza! thanks a lot for sharing by following this we can retrieve data from the sharepoint list as I saw in your other video but if we need to open that record and update it like in a form control will it be useful in that case? like if we include ID column to be returned and lookup actual list with the ID in the case of if record is 2001th of the list will it work?
@RezaDorrani
@RezaDorrani 11 ай бұрын
Not sure I understand your question. But the technique showcased supports fetching any item at any position
@benseaburg9608
@benseaburg9608 Жыл бұрын
Hi Reza, thank you so much for this video. This is brilliant. I have managed to get a screen setup and the gallery is finding the correct amount of previous versions for the record, but it displays the same information for each record in the table picking up the itemversion variable. I have traced through the HttpRequest action in the monitor tool, but I am unable to figure out what I need to change so it displays the correct version history information. Do I need to change the code in the items property of the gallery which shows the versions aviaIlable. Currently it has Table(varItemVersion.value). Or do I just need to amend the code in the text property of the gallery? Currently is has Gallery3.Selected.Points. Thank you very much,
@RezaDorrani
@RezaDorrani Жыл бұрын
Most welcome. The steps are all highlighted in the video. No code change is needed. I would recommend checking video again. If issue persists in your case, then recommend to post issue with screenshots on the forums at powerusers.microsoft.com
@benseaburg9608
@benseaburg9608 Жыл бұрын
@@RezaDorrani Thanks Reza. Sorry just to confirm, what do you have set in the text property of the gallery which shows the previous versions?
@benseaburg9608
@benseaburg9608 Жыл бұрын
Also, one of my SharePoint columns are set as a number instead of text. Is that ok?
@RezaDorrani
@RezaDorrani Жыл бұрын
@@benseaburg9608 I do not remember it exactly now. Check the output of the versions api in monitor and traverse through it.
@RezaDorrani
@RezaDorrani Жыл бұрын
@@benseaburg9608 All column types are supported
@durgayenwjnkjd
@durgayenwjnkjd 3 ай бұрын
Great video! Is it possible to get user details of a SharePoint group?
@RezaDorrani
@RezaDorrani 3 ай бұрын
I probably have done videos on it.
@durgayenwjnkjd
@durgayenwjnkjd 3 ай бұрын
​@@RezaDorrani Thanks for your reply! Through item level permission the security is managed, but is there a way with the Graph API?
@RezaDorrani
@RezaDorrani 3 ай бұрын
@@durgayenwjnkjd Probably! Not something I have tried though
@jadha_ravi
@jadha_ravi Жыл бұрын
@RezaDorrani How to do post method by using office 365 group connector to update/creates sharepoint list items
@RezaDorrani
@RezaDorrani Жыл бұрын
I did show how to post in my video. Creating updating list items is directly possible in power apps so not sure why would you want to use graph for that. But it is possible, check the graph api documentation to see how that can be done:
@atifuzzaman
@atifuzzaman Жыл бұрын
Office365Groups is the way to call any external API or it is only for graph API? What is the difference between custom connector and office365? I recently used custom connector for calling external API.
@RezaDorrani
@RezaDorrani Жыл бұрын
It is only Graph API as far as I know. There is a premium http action for external APIs. Custom connector is a premium feature.
@sheosanjaykumarsingh7440
@sheosanjaykumarsingh7440 Ай бұрын
do we not need to do app registration and custom connector if we need to use it in flow? Please let me know if we still need to have a custom connector or not. thanks Rezza
@RezaDorrani
@RezaDorrani Ай бұрын
Depends on how you are calling the graph api.
@10xApe
@10xApe Жыл бұрын
Hey Ezra is the SharePoint list good place to load 60000 rows register and maintain it there? Also what's the easiest way to load it from Excel at the start?
@RezaDorrani
@RezaDorrani Жыл бұрын
learn.microsoft.com/en-us/microsoft-365/community/large-lists-large-libraries-in-sharepoint
@sagarshinde4527
@sagarshinde4527 9 ай бұрын
Hi Reza, How export data in GraphQL API using ABP Framework. Please help me out provide related documentation.
@RezaDorrani
@RezaDorrani 9 ай бұрын
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@mspowerassist
@mspowerassist 6 ай бұрын
Hi @Reza, as part of the Graph API consumption we are extracting drive and site IDs right, how can we manage this during deployment to other environments? Since it is a one-time job, maintaining those as configuration information? Please suggest.
@RezaDorrani
@RezaDorrani 6 ай бұрын
Look into environment variables
@mspowerassist
@mspowerassist 6 ай бұрын
@@RezaDorrani yeah. I am also in the same page. But getting drive and site IDs would be a one-time manual job to update environment variables right?
@RezaDorrani
@RezaDorrani 6 ай бұрын
Env variables can be updated automatically via pipelines as solutions get deployed to downstream environments
@mspowerassist
@mspowerassist 6 ай бұрын
@@RezaDorrani makes sense. Thank you Reza for your inputs as always.
@kristian4805
@kristian4805 Жыл бұрын
Damn i would like to make something with "Get presence", but i see i wont be easy
@RezaDorrani
@RezaDorrani Жыл бұрын
I have not tried that hence not sure
@kristian4805
@kristian4805 Жыл бұрын
@@RezaDorrani Its not anywhere as an official data source as i see. And the Get Presence also being a little new. But I would like to build something for receptionists maybe. Where they can easily see someones online presence, and calender. Many i know dislike Teams a lot where they haft to get most of this information in Outlook, and it can be slow if you have 200+ peoples calender, and you have some customer waiting on the phone.
@mspowerassist
@mspowerassist Жыл бұрын
A quick question @Reza - I heard we can use the Graph API to bypass the MFA pass code screen (this scenario to authenticate users in PAD). Any thoughts on this?
@RezaDorrani
@RezaDorrani Жыл бұрын
I have no clue about this. Never tried it or heard about it.
@mspowerassist
@mspowerassist Жыл бұрын
Hmm..thank you Reza for the prompt response.
@robertadincalevis3800
@robertadincalevis3800 8 ай бұрын
Would it be possible with this method to also check the status (e.g. error) of the PUT request after running it? I tried but can't manage because the status it's not under "body".
@RezaDorrani
@RezaDorrani 8 ай бұрын
I have not tried it but I dont think its possible directly within power apps. You would need to call flow.
@acm-yo4mp
@acm-yo4mp Жыл бұрын
Can we use the Graph API instead of the SharePoint connector?
@RezaDorrani
@RezaDorrani Жыл бұрын
Yes
@dddrrr7139
@dddrrr7139 3 ай бұрын
can you make a video how to not use the invoke http request premium connector in power automate to use graph api? is it free to do a custom connector? send an http request doesnt give you the full range of graph api features, like microsoft teams presense, at least not in power automate, so how do you get around this?
@RezaDorrani
@RezaDorrani 2 ай бұрын
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
@malikhan0123
@malikhan0123 5 ай бұрын
Hi raza ..can we connect graph api to third party apps..if yes what are authentication methods..is there end points to dataverse tables?
@RezaDorrani
@RezaDorrani 5 ай бұрын
I believe there is graph connect but not something I have delved into
@fenrir433
@fenrir433 Жыл бұрын
Is it possible to have the Get request be dynamic in that it GETs the Profile info of someone who inputs in a userPrincipalName and the Get Request can get that UPN ?
@RezaDorrani
@RezaDorrani Жыл бұрын
Possible
@antoniokimble5286
@antoniokimble5286 Жыл бұрын
@RezaDorrani I wasn't sure on where to ask this so I'm posting it here since it's related to the subject. It's awesome being able to display the version history now! I ended up putting the API call on the OnSelect Property of the gallery instead of a button. That aside, I ran into an issue trying to combine two ideas, exporting the version history into a csv. We've done the exercise in the past of collecting the contents of what's in the gallery and exporting it into a csv. I was attempting to replicate this with the version history, and while I don't get any errors, and the file comes up, it's always empty. I've tried a few ways in hopes of figuring this out including collecting a single column, ThisRecord.Value.id, or 'Gallery Name.Selected.Value.id, or even removing the ForAll loop and collecting the typecasted table. Would you have any advice on achieving this? As a side note, I am not filtering which version fields coming in from the API call just in case I needed to change what was shown in the gallery. Update: I can at least see the collection capturing data once I commented out clearing the collection. At this time the csv file isn't displaying the information. Checking the workflow, the Content_Inputs is capturing elements in an array, but they're all blank. So close yet so far away, lol.
@RezaDorrani
@RezaDorrani Жыл бұрын
I do not have a video reference on your scenario and would have to try it out to provide guidance. I understand part of it was showcases but not the end to end version. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@FleedX
@FleedX Жыл бұрын
Do you know how to do a Filter(Table1,LookUp(Table2,Table2.Field=Table1.Field)) on a gallery?
@RezaDorrani
@RezaDorrani Жыл бұрын
Not by simply looking at a formula here on chat. I would recommend posting your query on forums with screenshots of scenario powerusers.microsoft.com
@RockStar-ft6db
@RockStar-ft6db Жыл бұрын
In power automate how can i connect with Adobe service .can you explain where i can find the client id and client secret .if possible can you make video on that
@RezaDorrani
@RezaDorrani Жыл бұрын
Video is on Graph API and Power Apps :) I have not done any work with adobe service. I recommend posting your query on forums at powerusers.microsoft.com
@Brahmateja3
@Brahmateja3 6 ай бұрын
Hi Reza , Is there any possibility to get Access token from Graph API ?
@RezaDorrani
@RezaDorrani 6 ай бұрын
Not sure
@user-cn9ft6ht1g
@user-cn9ft6ht1g Жыл бұрын
can you please guide how to create an app using speech to speech Azure Open AI API?
@RezaDorrani
@RezaDorrani Жыл бұрын
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@RedCloudServices
@RedCloudServices Жыл бұрын
is this Microsoft creating it’s own wrapper for GraphQL? The query doesn’t look like GraphQL spec at all
@RezaDorrani
@RezaDorrani Жыл бұрын
This is the Microsoft Graph API. Links to documentation is in video description
@MSTechInsights
@MSTechInsights 7 ай бұрын
Hello Reza, This was working earlier, but when I tried to do this same thing today in my new canvas app. I am not able to find the ParseJSON experimental feature. I can see the ParseJSON as a function when I am trying to invoke it on a button click though. The issue I am facing now if I use the V1 version n(deprecated) I can call the API and get the response but it is of type "unsupported object". If I use it with version V2 it gives me an error. Please suggest.
@RezaDorrani
@RezaDorrani 7 ай бұрын
ParseJSON is now GA and there is no need to enable it. v2 only includes certain endpoints. I have done 3-4 videos on graph and searching and shown different options to get data.
@merlinvusmann5962
@merlinvusmann5962 5 ай бұрын
@@RezaDorrani Hmm, I have the same issue. I tested to get data " my profile", but the variable is automatically set to 'boolean' , i get in monitor all data -this is ok, but i dont how and cant data to PL screen :)
@RezaDorrani
@RezaDorrani 5 ай бұрын
@@merlinvusmann5962 Try with a new app
@Deadpool12353
@Deadpool12353 Жыл бұрын
I just need to know how to extract cost centre and gin numbers from the ldap using graph.
@RezaDorrani
@RezaDorrani Жыл бұрын
I have no clue about that
@Anand_Mohod
@Anand_Mohod 6 ай бұрын
Hello How we can get all azure AD users using graph API in PowerAutomate ? I did implemented pagination to get result with basic details (name,UPN,dept) and I'm able to get all 40k users but when I'm trying to get 'manager' attribute didn't getting the all 40k result.
@RezaDorrani
@RezaDorrani 6 ай бұрын
I have not tried this so not sure
@karimobaid830
@karimobaid830 8 ай бұрын
Can a new SharePoint site page be created using Graph API?
@RezaDorrani
@RezaDorrani 8 ай бұрын
If graph api supports that then yes. Best to check graph api documentation
@AbhishekSharma-rn6oj
@AbhishekSharma-rn6oj Жыл бұрын
Sir, I'm using GraphApi the same way, but it is saving boolean value in the variable instead of untyped. Why's that?
@RezaDorrani
@RezaDorrani Жыл бұрын
Try it in a new power app.
@Aaravjoshishow
@Aaravjoshishow 10 ай бұрын
Hi, I am trying to get the display name of the group owner from graphapi in lable but it says the number passed in is a blank value. However I can see the display name on the monitor.. could you pls help on this
@RezaDorrani
@RezaDorrani 10 ай бұрын
I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@sophiadcosta-braganza5954
@sophiadcosta-braganza5954 11 ай бұрын
Hi Reza, how can I delete premium connectors please? Seems there is one in an app I created, which only shows up when I try to share the app with someone.. I am not able to remove it.. Any suggestions will be much appreciated. Thanks..
@RezaDorrani
@RezaDorrani 11 ай бұрын
If you are able to edit app, then you can remove the connector from app
@nehasrivatsava94
@nehasrivatsava94 Жыл бұрын
how i Can add Get profilePhoto in my powerapps through Graph APi?
@RezaDorrani
@RezaDorrani Жыл бұрын
I have not tried that. Best to check graph api documentation for that.
@rameshc4498
@rameshc4498 Жыл бұрын
Hi Reza, Here I have one question when I checked the list columns in the search schema option my list columns are not available, because of this I am unable to retrieve those columns. What I have to do for retrieve those columns
@RezaDorrani
@RezaDorrani Жыл бұрын
For that you would have to create managed properties in SharePoint search that map to crawled properties. I will recommend checking documentation on SharePoint search managed properties.
@rameshc4498
@rameshc4498 Жыл бұрын
@@RezaDorrani thank you so much.. can you please give more information about retrieve large items details like you mentioned in the video pagination area.
@RezaDorrani
@RezaDorrani Жыл бұрын
@@rameshc4498 I believe video shows how I did pagination. Video description has link to download sample app (members only).
@user-xh2cn5qk8c
@user-xh2cn5qk8c 11 ай бұрын
Hi Reza, I dont see the "Parse JSON and Untyped obects" feature in my powerapps list of "Upcoming Features" window and my authoring version is 3.23084.14. Was there a change made by Microsoft ? Thanks.
@RezaDorrani
@RezaDorrani 11 ай бұрын
Because it went into GA. No need to do that step anymore.
@user-xh2cn5qk8c
@user-xh2cn5qk8c 11 ай бұрын
@@RezaDorrani - Ok that makes sense, but now I am a getting a Boolean and not "UntypedObject" 😀 did some tests and it looks like this is not an issue if it's a new Canvas App. It fails in older or existing Canvas Apps. Wow.
@RezaDorrani
@RezaDorrani 11 ай бұрын
You simply delete the office365groups connection in your older app, save app, close app, edit app, add connection again and it should work
@ishareful
@ishareful Жыл бұрын
At 21:35, I did follow your other video, but what if I don't have access to Graph API (blocked by my admin). How can I laverage the link to my SP library to upload the file?
@RezaDorrani
@RezaDorrani Жыл бұрын
If no access to graph, then you would need to call flow to and pass file to upload it using SharePoint create file action.
@ishareful
@ishareful Жыл бұрын
@@RezaDorrani So the only choice withouth Graph API, What about if I will granted for the premium Graph API by my admin, will all my powerapps end-users is also required to have the GraphAPI premium?
@RezaDorrani
@RezaDorrani Жыл бұрын
@@ishareful There is no graph api premium. Its a single endpoint. How you call it makes it premium. I don’t understand that your admin has blocked graph api but you want to call premium graph api? There are always ways to do things. I simply put one option on table in my video.
@atulvijay100
@atulvijay100 Жыл бұрын
Thank you so much Reza for this video. I am using Graph API to get manager details of an employee. I am using graph API particularly to get the manager's & employees ID, hiredate etc., which is not available in ManagerV2. My body has 2 components, value having the entire table with manager + employee details & also manager details {}. I would like to call the particular items according to my needs like display name of my manager not the employee. But unfortunately its showing blank. Can you please provide me a solution on this. Also Office365Groups.HttpRequestV2 is throwing an error, when i try to take particular information from the same.
@RezaDorrani
@RezaDorrani Жыл бұрын
V2 was throwing error for me as well. I dont know why. Httprequest works. I would have to try out your scenario to provide the steps. I have shown steps in video on how to traverse JSON and my next video will also show more in detail. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@malangdarboe4148
@malangdarboe4148 Жыл бұрын
Do you have a link to the task tracker app?
@RezaDorrani
@RezaDorrani Жыл бұрын
No
Meet the one boy from the Ronaldo edit in India
00:30
Younes Zarou
Рет қаралды 13 МЛН
PowerApps Delegation with SharePoint as a Data Source (Part 1)
20:36
Managing with Microsoft Graph (and PowerShell)
33:21
John Savill's Technical Training
Рет қаралды 45 М.
PowerApps - SharePoint Search In PowerApps using MS Graph API
14:27
M365 Tech Help
Рет қаралды 1,4 М.
Editable Grid in Power Apps | SharePoint List
42:49
Reza Dorrani
Рет қаралды 368 М.
DELEGATION in Power Apps | Must Know to build efficient Apps
13:00
Reza Dorrani
Рет қаралды 45 М.
How You Can Use The Microsoft Graph API in C#
6:30
Blue Hippo
Рет қаралды 16 М.
How to get a Haircut in English
15:40
Ariannita la Gringa | Native English Teacher
Рет қаралды 28 М.
GraphRAG: The Most Incredible RAG Strategy Revealed
10:38
Mervin Praison
Рет қаралды 31 М.
Top 25 Power Apps Tips, Tricks & Best Practices for Makers
26:57
Reza Dorrani
Рет қаралды 65 М.