Thank you very much Reza ! With your method, I was able to reduce a 40 mn long flow to only 3 mn (delays included). You're simply the best !!! 👍
@RezaDorrani
20 күн бұрын
Fantastic!
@simonball5602
19 күн бұрын
Reza - thank you for all the content over the years. Your work is greatly appreciated and, in my opinion, has helped with positively changing peoples lives and getting people to think about various solutions that would never have been delivered without your content. Thank you again.
@RezaDorrani
18 күн бұрын
Thank you so much for your kind words and thoughtful message. It means a lot to hear that my work has had a positive impact and has helped spark new ideas. I'm truly grateful for your support, and I'm glad to have contributed in a way that’s meaningful.
@dougydoe
23 күн бұрын
Great Video. My biggest takeaway was the use of the Graph API to perform the copying into Excel. Was also nice to see you prefer using the Select action over Apply to each to significantly reduce API calls making the flow more efficient. Tested it in my environment and it works perfectly. Thanks for sharing. 😄
@RezaDorrani
23 күн бұрын
Glad it was helpful!
@yacobmusic
12 күн бұрын
Thank you Reza! Excelent aportation to the community.
@RezaDorrani
12 күн бұрын
Most welcome!
@Wotsefaqq
22 күн бұрын
I now have to rewrite several flows in my organization but that will save me a lot of actions ;-) Great video, thank you, Reza
@RezaDorrani
22 күн бұрын
Glad it was helpful!
@SudhirKesharwani
14 күн бұрын
Thanks a lot Reza, another amazing video from your side, This is what every Power Apps developer need.
@RezaDorrani
14 күн бұрын
My pleasure
@iddycol
16 күн бұрын
A great video that showcases an important (and under used) technique - Thanks for sharing.
@RezaDorrani
16 күн бұрын
Glad it was helpful!
@AMindGame
21 күн бұрын
Always top quality content. Very straighforward approach. You're the GOAT Rezza.
@RezaDorrani
21 күн бұрын
🐐
@pkprotoplasm
23 күн бұрын
I wish the new Flow designer worked as well for me as it seems to for you 😅 Great video!
@RezaDorrani
23 күн бұрын
You got to handle it with care
@PaulSpronck
20 күн бұрын
Great Reza, very clear explanation, works like a dream and is very fast!
@RezaDorrani
19 күн бұрын
Great to hear! Fast and efficient
@mdhidayat5706
23 күн бұрын
Thanks Reza for sharing the video! Just gave me the idea to replace the trigger from manual to Run from PowerApps
@RezaDorrani
23 күн бұрын
Hey, I have another video coming where I mix this with run from Power Apps and make it super dynamic. Watch out for that one.
@anilkumar-ml2sl
23 күн бұрын
Finally I'm getting a taste of how to use APIs, thanks to your 'simple explanation' 🤘
@RezaDorrani
23 күн бұрын
Great to hear!
@joaopaulofritzen9187
23 күн бұрын
Thank you so much for this video, really interesting method. I have some flows that do the opposite (I periodically receive an excel file in my inbox, the flow triggers to save it to my sharepoint -> convert to table -> add table rows to a list). Do you have any idea if this method could be used in this order of operations? (using the select method with graph api to add table items to a list)
@RezaDorrani
23 күн бұрын
I have ideas for that also. Im planning videos for both SharePoint and Dataverse. Waiting to see the response for this video first.
@GSoftagon
14 күн бұрын
Excellent!!!
@RezaDorrani
14 күн бұрын
Thanks
@mrnock2
23 күн бұрын
Great video and straight to the point as usual Reza. Many thanks for sharing your knowledge with the community. One little question if I may... Could you please be so kind to post a video using the same approach but using Dataverse as a final backend with all 4 CRUD actions? I am struggling when using the HTTP connector (premium). Again, many thanks for your continuous support! 🥇
@RezaDorrani
22 күн бұрын
Thanks! I have plans for bulk action videos related to Dataverse and SharePoint. I’m waiting to see the response to this video.
@tristangeoffroy9286
23 күн бұрын
Hello Reza, once again It’s awesome vid. You really want us to get addicted. Thank you. You make me want to invest much on graph
@RezaDorrani
23 күн бұрын
Graph is KING
@yoginathbadadale
22 күн бұрын
You are amazing Reza !!❤
@RezaDorrani
22 күн бұрын
Thanks
@francescofornasiero5071
20 күн бұрын
Grateful for this video, thank you very much. Alone I'd never been able to do it.
@RezaDorrani
20 күн бұрын
Glad I could help
@francescofornasiero5071
9 күн бұрын
@@RezaDorrani I've got a dataverse table to export actually, is the way similar?
@RezaDorrani
9 күн бұрын
@@francescofornasiero5071 pattern would be similar
@JohnsonVettuvelil
23 күн бұрын
Thanks for the share. Avoiding the apply to each is a great way! 👏 Can we bulk update a SharePoint list using graph api similarly? Any links that you can share?
@RezaDorrani
23 күн бұрын
Yes, there is batch api for SharePoint as well. Il plan a video on that and Dataverse in future.
@mohammedm2018
22 күн бұрын
Great tutorial Reza. Thanks for sharing. What account permissions are required for accessing Graph API? I have several use cases to improve my existing flows.
@RezaDorrani
22 күн бұрын
The API shown in video uses delegate permissions. Basically uses the existing access of the user.
@shaikhfirdos2723
23 күн бұрын
This is really awsome trick..thanks Reza🎉❤
@RezaDorrani
23 күн бұрын
Most welcome
@jyotidatta2126
3 сағат бұрын
Hi Reza, Great and very informative video. Quick question, can you please let me know if instead of one drive as placeholder if we can use excel file in SharePoint location? Will be awaiting your reply.
@oluwatobiyusuf
18 күн бұрын
Thank you Reza.
@RezaDorrani
18 күн бұрын
Most welcome
@kishorekrishna83
15 күн бұрын
Great video I like it❤
@RezaDorrani
15 күн бұрын
Thanks
@jamesbergmann4322
18 күн бұрын
Thx Reza Useful as always. Any suggestions on how to use this to populate the gathered data to SharePoint list rows without iterating through every record?
@RezaDorrani
18 күн бұрын
Im working a video idea for SharePoint and Dataverse.
@jamesbergmann4322
18 күн бұрын
@@RezaDorrani Looking forward to it! If I can still influence your script for that video… I often need to bulk delete and bulk add items to sharepoint lists with a couple of hundred rows. Iterations are just very resource consuming. Keep up the good work!
@RezaDorrani
18 күн бұрын
@@jamesbergmann4322 Depends on how much I can squeeze in within 20 mins
@ericzheng4838
23 күн бұрын
Magician Reza!
@RezaDorrani
23 күн бұрын
Thank You!
@AB-iq9rl
13 күн бұрын
I truly appreciate for the sharing fabulous knowledge! Can you show how to export over a million records from a large table? directly to the local drive in the laptop...
@RezaDorrani
13 күн бұрын
I don't think a million records is supported. I don't have any video references on storing info on local drives. Not something I have tried.
@ChristosLepesiotis
2 сағат бұрын
Reza Thank you!!
@elliotavery6415
22 күн бұрын
Awesome video! Please could you a video on how to do the http action on a SharePoint file? 🙏🏼non premium if possible
@RezaDorrani
22 күн бұрын
SharePoint file? What type of file?
@Y0urN3m3sis
14 күн бұрын
@@RezaDorrani I think I understand his comment, as I am also looking for a solution for the same, what if we are creating the Excel file in a SharePoint document library
@RezaDorrani
14 күн бұрын
@@Y0urN3m3sis I'm sure there would be a graph api endpoint for that as well. I don't have any plans for that video as of now.
@Y0urN3m3sis
13 күн бұрын
@@RezaDorrani I used your method, and it was ultra-fast. As a workaround, I decided to first create the file on OneDrive and then move it to the document library and delete the instance in the OneDrive, due to information security reasons. I read the comment thread, would you be able to give me a hint, if I can do this in one go through Send an HTTP request to SharePoint, Rest API? I couldn't find the right end points though.
@RezaDorrani
13 күн бұрын
@@Y0urN3m3sis I would have to explore that to know if there is a one shot rest api
@susann3331
5 күн бұрын
Thank you for this video, it was very helpful. I am working with SQl tables and view with very large datasets. I have a gallery that filters from multiple combo boxes and search field. The gallery only shows a few columns. is it possible to export all selected items in the gallery and include all my columns from SQL view?
@RezaDorrani
5 күн бұрын
I have done no work with SQL, hence not sure of the options there. I would recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com/
@akshitjuneja2387
16 күн бұрын
Hi Reza, Thank you for all the amazing videos you share! :) Regarding the Graph API approach, I used it last month and found that the JSON payload can be a maximum of 4 MB when posting data to an Excel file. Do you have any ideas on how to handle JSON payloads larger than 4 MB?
@RezaDorrani
16 күн бұрын
I am not aware of the max payload size. I was able to export around 50k rows with a scenario for a customer. There get items thresholds itself is 100k.
@yoismelperez2744
19 күн бұрын
Thanks, very useful. Wondering if there is an equivalent endpoint to do the same for SharePoint List. I mean bulk insert or update of a SharePoint list.
@RezaDorrani
18 күн бұрын
Not a graph api but there is a batch api. I have plans for a video on it in future.
@yoismelperez2744
18 күн бұрын
@@RezaDorrani very nice. You're the best. Have a wonderful weekend.
@Sean-b3g5c
Күн бұрын
Thanks Raza, it works very well when Excel document is created in One Drive. Would it be possible for you to let me know what I need to change if documents are saved to SharePoint document library? I am getting 'Send_an_HTTP_request' failed" Invalid request.
@RezaDorrani
Күн бұрын
SharePoint would be a different process and not something I have explored
@aka9898
23 күн бұрын
Thanks for this video, can you create a video on pulling multiple attachments from SharePoint list and save it to the documents library with naming conventions to understand the underlined file from the list .....
@RezaDorrani
23 күн бұрын
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.
@tibobago
13 күн бұрын
Can't believe you're replying to nearly every comment! ✨✨
@RezaDorrani
13 күн бұрын
I am! You will have to believe it 😊
@islamshaban216
23 күн бұрын
Great❤
@RezaDorrani
23 күн бұрын
Thanks!
@faizalreza9087
15 күн бұрын
Hi reza, im new for this platform and trying to copy what u do. but, at create table, specifically at document library, none of it called onedrive. is it a default choices or u create the library by ur own? thank you reza
@RezaDorrani
15 күн бұрын
It's a default choice for all. Video description has link to download entire solution (members only - check description for details)
@Youngsma
14 күн бұрын
Is this solution also possible for updating/patching an existing excel table? Obviously with a patch/put api
@RezaDorrani
14 күн бұрын
Have not explored that
@cyberMythius
16 күн бұрын
Is there any chance to use similar approach to load / modify / delete data in sharepoint list?
@RezaDorrani
16 күн бұрын
Future video planned!
@RJ21Wanderers
23 күн бұрын
Another way can be to use Office Scripts to Create Excel in One Go, using it we can generate complex excel exports.
@RezaDorrani
23 күн бұрын
Yes
@PaulSpronck
19 күн бұрын
Works like a charm!. But I can't get the output of a query on a PowerBI dataset in the body of the HTTP Post: { "values": outputs('Query')?['body']} does not work ! What reading material do you suggest?
@RezaDorrani
19 күн бұрын
Thanks! The values must be an array of arrays as shown in video. You would need to ensure the power bi dataset output matches that pattern.
@PaulSpronck
17 күн бұрын
@@RezaDorrani Fantastic, thanks much for your tip. Works fine....all one needs to do is FOLLOW INSTRUCTIONS! 😊
@mohammedm2018
16 күн бұрын
Hi Reza. With the Top Count set to 5000, and pagination set to ON, how does it return more than 5000 items? Isn't Top Count going to max it?
@RezaDorrani
16 күн бұрын
No. Pagination will load data in batches of 5000. Try it out and test it.
@mohammedmerchant5628
15 күн бұрын
@@RezaDorrani 15000 rows done in total flow time 30 sec, this is amazing. Yes the top count worked as you mentioned. I think I saw it limiting the records with the Excel connector but this is the SP connector. The HTTP request action took 5 sec only. Perfect for many scenarios. Looking forward to your next for writing to SP.
@happythepig5089
17 күн бұрын
Damn, I just spend 24 hours learning how to do the exact same task, though with data from power apps, even created a custom graph connector, and had to wrangle with text to json etc....... Should've just checked in with Reza
@RezaDorrani
17 күн бұрын
Sorry for giving you the trouble to rebuild the flow :)
@happythepig5089
17 күн бұрын
@@RezaDorrani All good 🙃
@aamiuk1
13 күн бұрын
Reza when can we expect a video an end to end video of integrating Gen AI with PowerApps with lot of noise that's around regarding the same a video will help us
@RezaDorrani
13 күн бұрын
I have not heard any noise from anyone :) 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.
@sandeepadode1
21 күн бұрын
I am facing an issue with the http post approach. For 5k records it works fine. But the moment is pass 70k records, it throws 302 error with message as the response is not in a json format and with internal error as cannot read server response. Had anybody faced similar issue. I am trying to figure out the reason it works for 5k records and not for huge list of records makes me wonder if it's the api limitation.
@RezaDorrani
21 күн бұрын
Video itself shows 10k+ records. I have not tested with 70k+ so not sure if there is any limit there. Logically it should handle up to 100k.
@sandeepadode1
20 күн бұрын
@RezaDorrani Thought so too, but unfortunately it won't work for bigger set. Also, I think it has something to do with excel service limits.
@Ashba822
9 күн бұрын
@@sandeepadode1 I am also facng the same issue , my table consists of 200 columns and 50k rows, tried all the approaches from my end, @rezadorrani could you hep us in figuring it out ?
@Ashba822
9 күн бұрын
@@RezaDorrani It is not working for 50k rows
@RezaDorrani
9 күн бұрын
@@Ashba822 Probably depends on how many cols included.
@kylecullenvdw
28 күн бұрын
Hi Reza, I see you used OneDrive throughout the process. What if I wanted to only use SharePoint. Could I follow a similar process using the Invoke Http action and populate the excel stored in SharePoint via the Graph API?
@ericmild4050
27 күн бұрын
Maybe you just add a new step to copy the newly created file to your Sharepoint Group?
@RezaDorrani
27 күн бұрын
The graph api also has option to point to SharePoint. In the video, once I build the file - I save it in SharePoint library as well.
@RezaDorrani
27 күн бұрын
I see you tried posting a link which gets blocked by my channel settings. I wanted to let you know that.
@kylecullenvdw
27 күн бұрын
@@RezaDorrani 👍
@gpoogles
24 күн бұрын
Hello Reza, Thanks for this video. Unfortunately I'm getting the following error, "unable to process template language expression in action 'send an http request' inputs at line 0 and column 0. The template language function split expects it's first parameter to be of type string. The provided value is of type Null. Can you pls advise what could be an issue.
@playwithdaneenanabiauzair6191
14 күн бұрын
Its possible we can use upsert using the graph. Beacuse simple create not work in my cases.?
@RezaDorrani
14 күн бұрын
I have not explored that option
@kirane7000
19 күн бұрын
Not related to video. Is it possible to get notifications from trigger failures of power automate ? Which managed table would give you those details?
@RezaDorrani
19 күн бұрын
Not sure which managed table has that information.
@sandeepadode1
9 күн бұрын
@kirane7000 Not sure if I get this, but I can say what we did. We have a powershell script that is scheduled to get flows every 30min for failures and send an email to the development team take a look at it and fix any issues with the failed flows.
@surajrevankar6062
20 күн бұрын
Whats the maximum number of items excel will support. Or whats the maximum excel file size will it support 😊
@RezaDorrani
20 күн бұрын
I am not aware of what that size limit is
@videobewerker111
21 күн бұрын
I want to make the table read only and add 2 columns (extend 'yes/no' and 'due date' if yes) that are editable for the receiver. Group the excel for every firmname and send it to the email of responsible firmcontact. How to ...
@RezaDorrani
21 күн бұрын
Does excel support making table read only and 2 columns that are editable?
@Copy-kodadam-mama
21 күн бұрын
Hi reza, could you please make a video on the number to word conversion.(ex:123.60 ,one hundred twenty three dollars and sixty cents)
@RezaDorrani
21 күн бұрын
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.
@Copy-kodadam-mama
21 күн бұрын
@@RezaDorrani first of all thank you for your response,could you please share a blog with me ,if you have number to word convertion
@RezaDorrani
21 күн бұрын
@@Copy-kodadam-mama I don’t have any blog references for this. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@bokzefco2843
23 күн бұрын
It is possible to create a text file (.txt) instead an excel file? (.xlsx)?
@RezaDorrani
23 күн бұрын
Not with this approach. Not sure about options for txt file.
@mk15minut64
23 сағат бұрын
From where can i download a copy of thr flow?
@RezaDorrani
22 сағат бұрын
Video description has details on how to download entire solution (members only - check description for details)
Пікірлер: 133