Top 25 Power Automate flow tips and tricks for 2021 - hidden gems and new features

[@juansepowerplatform]

This video is a must for everyone creating flows, 30 minutes of pure knowledge. Thank you Reza

[@RezaDorrani]

Thank You

[@michaelcomer1645]

Agreed this is amazing content

[@danielrumbak2530]

100%

[@Inovators]

Yeah it's really very helpfull

[@lukebrunning4725]

I've learned more in this one video than *everything* else I've read/watched/listened to on Power Automate... thanks Reza!

[@RezaDorrani]

Great to hear! Thank you for watching.

[@nandansubramanya]

I have been using flow for a while now, did not expect to learn much. I was wrong. Learnt a lot.... I am still on tip 15, and so impressed that I was compelled to leave a comment

[@RezaDorrani]

Thank you for watching and so happy to hear the feedback.

[@Worrelpa]

Great Video Reza, lots of useful info, for beginners to pro;s, some I didn't know in there and I have been using Flow since its early days ;). My one tip I would add is in renaming actions. Rename them but leave the action type at the beginning. e.g. Get items - Project items That way you know exactly what type of action it is and what it does / its purpose. I always used to find that having a number of same coloured steps confused me about what type of action it was.

[@RezaDorrani]

Thank you for the feedback and +100 for your tip.

[@MoonChilde72]

You should have way more views. This really gets into the nuts and bolts of Power Automate, well beyond just tips and tricks. Peek code and concurrent loops as just a couple of thing we all needed to know. Awesome video, and thanks for making it.

[@RezaDorrani]

Wow, thanks!

[@amitmann6377]

watched your all powerapps videos and started power automate..and starting itself is this GREAT video.

[@RezaDorrani]

Thank You

[@mirzaKaisar-h6w]

App hindi me banuna yh vedio hmm log urban areya se h

[@gabriellopez505gl]

Crack! You are a big heroe for all analyst in spain! Thanks a again for this kind of video. Saludos desde España

[@RezaDorrani]

Love to Spain.

[@cvkealey]

Thank you for providing such a comprehensively useful resource! I have a LOT of folks asking me "how do I get started with Power Automate?" Now I know where to send them! On a slightly different topic, I've been fiddling around with the "Power Automate Management" connector's actions and built a few flows to help inventory and manage my flows (I'm planning to record a video showing how I did that, just waiting to work out some of the bugs). I now have a Microsoft List (called "My Flows") that serves as my master inventory. One bit of information that I haven't found a good way to retrieve is the timestamp of the last run for a given flow. I know I can get that when a flow runs, but that would mean adding a step to all of my flows, some of which run as other users, who don't have permission to my "My Flows" list). I was hoping it would be an output value/property of the "Get flow" action, but it's not. Any ideas?

[@RezaDorrani]

Thank you for the amazing feedback. I have not done much work with the management connectors. Always best to check documentation docs.microsoft.com/en-us/connectors/flowmanagement/#:~:text=Power%20Automate%20Management%20connector%20enables%20interaction%20with%20Power,should%20call%20actions%20with%20the%20%27as%20Admin%27%20suffix. Or Post on the forums at powerusers.microsoft.com/

[@JD-lx3cx]

Even the video is recorded a yeara go, it is still very help to summary Power Automate skills. Thank you Reza!

[@RezaDorrani]

Glad to hear that! Thanks so much for watching.

[@4Dibakar]

In a single video capturing these many important features is awesome.

[@RezaDorrani]

Thank you

[@Bekesam]

This fabulous for both beginners and advanced users. You packed alot in this video for a great reference. Thank you Reza!

[@RezaDorrani]

Thanks so much for watching and liking the video.

[@muhammadusmankhan5284]

I am new to power automate. All the things are going awesome as I found your channel, keep doing the good work, and thank you so much for such helpful content.

[@RezaDorrani]

Thank You so much

[@AHMEDALDAFAAE1]

I was searching for this kind of videos about Power Automate. Thank you so much!!!🤞

[@RezaDorrani]

You're most welcome!

[@Sunilprakashsabbithi]

Thanks Reza. Every time i watch your video, i learn a lot of new things which are very useful.

[@RezaDorrani]

Glad to hear that!

[@davidferrick]

I love the experimental features that allow dynamic content and expressions to be managed a bit easier; however, it is very quirky at times.

[@RezaDorrani]

Its experimental hence quirky :) Waiting for it to go GA.

[@headflask]

The flow run link and the trigger conditions really hit the spot. Thank you.

[@RezaDorrani]

Thank You for watching

[@ashu49]

This is 35 mins of pure awesomeness Reza.

[@RezaDorrani]

Thank You

[@gooseyclancy]

Brilliant :) Reza is the man I learned so much from this and other videos coming from workflow in D365 my fear of PA is now gone :)

[@RezaDorrani]

Thanks and glad to hear the feedback.

[@larrygleaner1683]

Thanks Reza! I really like the tips & tricks format of this video, and would love to see more like this!

[@RezaDorrani]

More to come! Working on a video on "What's new in flow" next!

[@MsAmyrock]

Excellent! I've been using Flow for years and I learned something new!

[@RezaDorrani]

Glad it was useful. Thank you for watching.

[@hellosubhahere]

first video that addressed concurrent and parallel action executions

[@RezaDorrani]

👍

[@dcpowered]

Reza, please make a new version of this video with more tips and tricks! This is extremely useful. Thank you!!

[@RezaDorrani]

Thanks, I will plan to once I have 25 more tips :)

[@balajimr2]

Going forward, I shall make it a habit to watch your videos.... Kudos for enlightening us with your knowledge... thanks

[@RezaDorrani]

Awesome, thank you!

[@techdelasabana]

Excellent video Reza. What do you think about this: In all my flows, the last action I add is "send me an email notification", checking all choices in "Configure run after" but "is successful". In that way, whenever there is any error in a flow, I receive an immediate notification, as opposed to being notified by Power Automate once every week which is the default notification period.

[@RezaDorrani]

Best idea would be to group actions using scope and do error handling. Ideally handle errors for actions which can potentially result in an error. Check flowaltdelete.ca/category/power-automate/flow/error-handling/

[@hcneyclouds5642]

I watched this video many times, And will be more to recall many good tips. Please make another versions for good tips like this

[@RezaDorrani]

Thank you for watching it many times. I will plan something on tips and tricks for flows and apps.

[@alzaimoor79]

indeed very useful tips, trigger condition, speed up apply to each and timeout handling, thanks for sharing.

[@RezaDorrani]

Glad it was helpful!

[@Evilship994]

its very informative and worth watching the language is simple and crisp

[@RezaDorrani]

Thanks for watching

[@KelasAutomation]

That was awesome videos! great to watch this, there is a lot things I learnt, especially with the additional setting and several setup you have explained. Thank you in advance :)

[@RezaDorrani]

Glad it was helpful!

[@joejoe485]

Hi Reza, just came across your channel. Your content is a gold mine. Thank you and keep up the job work

[@RezaDorrani]

Thanks Joe & welcome to the channel

[@tiruworkbezabih2222]

👍 What a great Summary! God Bless Reza Dorrani!

[@RezaDorrani]

Thank you 🙏

[@digamberhampa4537]

Awesome Reza, learnt lot of new things from you. Thank you.

[@RezaDorrani]

Happy to hear that! Thanks so much.

[@VikashKumar-fg2pm]

This is splendid video to know about power automate flow... Thanks Reza

[@RezaDorrani]

Glad you liked it

[@factsandreality6057]

You are Gem bro... I have enjoyed your video without any distraction...

[@RezaDorrani]

Thanks so much

[@anathipretty5414]

Great video Reza ,useful info all the way until the end, Please do videos like this for Power Automate Desktop as well

[@RezaDorrani]

Thanks. I did 1 video on PAD. I have a tips video planned on Power Apps. May be some day I will work on PAD tips.

[@broodled]

Amazing video from the genius of Power Automate

[@RezaDorrani]

Thank You for watching

[@sdponnekanti784]

Very Useful Information Reza and always fan of your work and explanation.

[@RezaDorrani]

Thanks

[@pennyp5822]

Thank You for sharing your knowledge Reza.

[@RezaDorrani]

My pleasure!

[@eymeeable]

Thank you for the tips, Reza! Please do videos like restricting/deleting a folder when a user uploads a .mov file within a folder.

[@RezaDorrani]

I will add your request to my backlog but this is the first request on this topic. I will need a lot more folks requesting this topic to give it a higher priority.

[@GaryCrant]

starts with a couple of very obvious "tips", but the further the video goes the better the tips get. thanks!

[@RezaDorrani]

Thanks for watching and liking the video.

[@HareKrsn213]

Waah... such videos always make me excited about technologies 😁😁cheers

[@RezaDorrani]

Glad to hear that

[@vinamrachandra9611]

Thanks Reza. Wonderful compilation. I love the way you present just at the right level (for me) of detail. Anyway I can contribute to your wonderful quest for sharing your knowledge? Also can you share the test workflow you used in the video?

[@RezaDorrani]

Thank You. Best way to contribute is by sharing my content within your networks if the content is worth it. The flow that I used has connections to SharePoint and other data sources. If I share the flow it would break since those lists would have to be created and setup. Some of the work and flows are available to download on my website at - rezadorrani.com/index.php/2021/02/14/power-automate-flow-expressions/

[@vinamrachandra9611]

@@RezaDorrani Thank YOU for wonderful content. I do share with interested people whenever I come across anything good like your posts. I will use the flows available at the link above.

[@VikasShankarMishra]

One of most informative video on Power Automate , Thanks a lot !!

[@RezaDorrani]

Glad you liked it

[@ybansan3270]

All the videos Reza made are excellent !

[@RezaDorrani]

Thank You

[@TheAlgebraTeacherPOWERStoBI]

I always enjoy learning from you. Thank you sir!

[@RezaDorrani]

My pleasure!

[@zhisonghuo]

This video is very helpful for me, Thank you Reza! I have subscribed your channel, your each video is my must read.

[@RezaDorrani]

Thanks so much

[@jrdtechnologies]

Excellant Work!!!! I learned so much valuable info

[@RezaDorrani]

Awesome! Thanks so much

[@huyfe1347]

Hi Reza. Thanks for this video. Did you make any video where you used HTTP request to post message/information on social media like twitter in response to an user post/message? Or any video on how to manage social media with power automate? Thank you Reza you are the best..

[@RezaDorrani]

I have not made any videos with relation to social media connectors. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@TheGoldyMack]

Hi Reza, Huge Fan. I'm currently having an issue with my Flow to upload Document to a SharePoint library. The flow works, but my app works by users assigned a document to update and upload back to the SharePoint library. My flow keeps overwriting my doc as it uses the same file name. I would like to add a time stamp to the file name to make it unique, but I'm unsure how to perform that action in my flow. I searched your videos for clues but was not able to find any that gave me ideas on how to execute that action. Any assistance would be greatly appreciated. Thanks

[@RezaDorrani]

I do not have a specific video reference on this scenario but have seen posts on forums related to it. I recommend to check on forums or start a new post on this topic powerusers.microsoft.com

[@zineddine]

Great video Reza, i am sure that i will come back to rewatch this video again and again till these tips become a habit. Question regarding renaming Triger/Action names, how can you tell the original Triger/action name that was renamed?

[@RezaDorrani]

Thank You! Flow currently does not have versioning (coming soon). As of now, no way to tell what the original name was.

[@gurbinderparmar688]

Excellent explanation in a nutshell.

[@RezaDorrani]

Thank You!

[@AMAlGhazali]

Great video like always.. some of the tips saved my time as I was achieving same results but in difficult ways

[@RezaDorrani]

Thank you for watching and happy to know that video is useful.

[@surrealsteel1]

Reza, I recently discovered your channel and you have helped me a lot. If you ever start a patreon or something similar, I'll definitely be signing up.

[@RezaDorrani]

Welcome and thank you for following my channel. Currently, my KZbin channel is where my focus is on :)

[@yt25user]

Absolutely loved all tips. Pure Gold. Thank you. Reza, Will you help doing a video about SharePoint & it's UI customisation ?

[@RezaDorrani]

Yes I will in future. I have a lot of ideas so stay tuned :)

[@yt25user]

@@RezaDorrani Thank you

[@KumarNaveen2711]

Thanks for giving detailed information about Power Automate tips

[@RezaDorrani]

Thanks for watching

[@jayantkumarjoshi270]

Really very much useful knowledge sharing. 👌👌👌 Each-n-every knowledge you shared in this video is absolutely much useful. And...I really appreciate the efforts you've put to make this video. The time you have invested in preparing this video will work like a ready-reckoner for us. Thank you very much, Reza. 🤝👍💐

[@RezaDorrani]

It's my pleasure

[@Rashomon69]

I regret that I have only one like to give. :)

[@RezaDorrani]

Il take that as 2 likes :) Thanks so much for watching

[@heenachhabra2977]

Gem of a video..Thank you so much for these 30 min of sheer knowledge..I was having trouble formatting the HTML table..do you discuss that in any one of your videos..btw the flow URL was an awesome thing that I did not know earlier

[@RezaDorrani]

Thank you for your amazing feedback on this video. HTML full video - kzbin.info/www/bejne/jJ-6mGB7pN1mbbM

[@ceciliachan9616]

Dear Mr Dorrani, Thank you so much for your teaching. Do you have some tips on composing Array for Merging PDFs into one PDF of Adobe API Connector? It is learnt that the API is hardly to use by quite a number of users.

[@RezaDorrani]

I have not done any work with Adobe API Connector. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@Everyonelovesyou]

Best utilized hour in this year

[@RezaDorrani]

Wow! Thank You.

[@Everyonelovesyou]

@@RezaDorrani Want to learn Power Automate. especially , how to send email reading data from incoming attachment email having simple table. apricate good performers, wakeup call to low performers. And much more to put my daily tasks at automation

[@RezaDorrani]

@@Everyonelovesyou I do plan to provide live training which will cover a lot of key concepts. Here is the link to one of my first live sessions - kzbin.info/www/bejne/iXeZmnlslqqbqaM

[@RezaDorrani]

Check channel memberships. I have gone live with a training tier that you can sign up for now. kzbin.infojoin

[@tristangeoffroy9286]

Hi Reza, a big thank you for this tremendous summary, it helps me a lot, and saves me time. It's also very useful to see how you're using it, your best practices based on your ground experience. ..so it's a very valuable gift you made to us (to me at least) ;-)

[@RezaDorrani]

You're very welcome! Thanks for watching & liking my videos.

[@premsai9908]

Thank you so much for quality content with sheer dedication. You will be remembered forever for your great efforts and help One small doubt how did you formatted html table.

[@RezaDorrani]

Thank You 🙏 HTML Table formatting - kzbin.info/www/bejne/jJ-6mGB7pN1mbbM

[@wendythiessen3718]

Love the video. I am working on using power automate to delete items from a SharePoint list that are more then a year old and was wondering if you have every done a video for this or if you could do a video for it.

[@RezaDorrani]

I do not have a video reference on this scenario. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@stavrosvogiatzis4016]

You are the best Reza, thank you.

[@RezaDorrani]

❤️

[@GrzegorzAndra]

Thank you for this video, it's very helpful :)

[@RezaDorrani]

Most welcome

[@ArohShukla]

As usual, a great video with fabulous tips.. can you make please video on Power Automate error handling?

[@RezaDorrani]

Thank You. Error handling is covered here - kzbin.info/www/bejne/inSso2p4mJiCodE

[@ArohShukla]

@@RezaDorrani Thanks !

[@krupaniv3667]

Very helpful video, Thanks Reza, one question if we rename the connection, later if I want to know which connection I am using? Where can I check that?

[@RezaDorrani]

Check comments for a great tip by Phil - "My one tip I would add is in renaming actions. Rename them but leave the action type at the beginning. e.g. Get items - Project items That way you know exactly what type of action it is and what it does / its purpose. I always used to find that having a number of same coloured steps confused me about what type of action it was."

[@krupaniv3667]

@@RezaDorraniThanq for your reply, I am doing the same way but want to know, like SPD is there any option for checking the name of connector

[@RezaDorrani]

@@krupaniv3667 I don’t think so.

[@gorgonhaas6429]

Excellent. Thank you VERY much.

[@RezaDorrani]

Most welcome!

[@skmaheswaran]

Great Video and useful for any beginners

[@RezaDorrani]

Glad it was helpful!

[@nitzan300]

Thanks a lot Raza! for your time and sharing with all fromyour knowledge, powerful session .

[@RezaDorrani]

Thank You for watching

[@SoumyaAnurag]

Great work Reza. Quite quick and informative.

[@RezaDorrani]

Glad you liked it

[@theodejong1123]

Hi Reza, Thanks for the video! Very helpful. I have got quite a specific question, I hope that your knowledge about Power Automate is sufficient for this case. I have a lot of Word documents, that contain bookmarks. These bookmarks have to be turned into Quick Parts in order for SharePoint to read them and auto populate rows. Any idea on how to automate this?

[@RezaDorrani]

I have not come across this scenario. Not sure what the possibilities are. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@umeshgaur6960]

Awesome Videos , the way of your explanation is exceptional 👍 I learnt lots from your Powerapps and power automate videos.

[@RezaDorrani]

Thank you so much

[@umeshgaur6960]

@@RezaDorrani Can you please make some videos on custom connector available in GitHub.

[@RezaDorrani]

@@umeshgaur6960 I will once I learn how to do it :)

[@umeshgaur6960]

@@RezaDorrani thank you Reza, I am waiting for it.

[@praburadha8818]

You are a rock star @reza. Thanks a lot for your videos. They help us a lot.

[@RezaDorrani]

You are most welcome

[@siva65kumar]

Very useful information. Thanks Raza

[@RezaDorrani]

Thanks for liking

[@ashrafjavali2841]

Wow!!! Great very useful tips. Thank you Raza

[@RezaDorrani]

My pleasure 😊

[@conaxlearn8566]

That's very informative. Thank you. I am a bit stuck though on the concurreny bit. Someone created a flow that triggers everytime an item is added to a SharePoint list. The triggered flow then creates a new related item into another SharePoint list, and updates the 'Processed' field to 'Yes' in the source list. The problem is each time, there can be hundreds of items created into the source list at the same time, causing multiple instances of the flow to trigger, and eventually a lot of them ended up in Running state for many many many hours. Enabling concurrency and then reduce down the value (like to 5 or 10) helps, but does not gurrently to get rid of the issue totally. There are always some flow instances that get stuck in Running. Does that mean I need to set the concurrency value to 1? Would that gurentee no flow instances will get stucking in Running then?

[@RezaDorrani]

There are threshold limits per connector. Example SharePoint has 300 calls per min (I think). I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@ramakrishna76]

Hi RD, good day. First of all thank for sharing knowledge in Power Platform. I'm new to this and I have question? how to pass parameter in my custom REST API( in this its accepts id as parameter and based on id it will retrive data from API). its works fine in custom connector in PowerAutomate. but when try in flow, Not understand how to pass my parameter into the my action. Much appreciate your help

[@RezaDorrani]

Most welcome! 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

[@vigneshkumar271]

It is a awesome video. I like every tricks a lot especially the error handling part.

[@RezaDorrani]

Glad to hear that!

[@HELVETASNepal]

This is fantastic Reza, could you please guide me how to add number of days from Leave table based on the type of leave taken by an employee

[@RezaDorrani]

Thanks. I do not have a video reference for your use case. I will recommend checking on the forums at powerusers.microsoft.com

[@gosodre4279]

Excellent video Reza, congratulation. It was helpful. :)

[@RezaDorrani]

Glad to hear that!

[@nikolaidedenkov8414]

Thank you, Reza Could you please cover the topic of getting messages in MS Teams triggered by an incoming email?

[@RezaDorrani]

Will add it to my backlog but this is the first request on this topic. I will need a lot more requests on this topic to give this a higher priority.

[@sueamin2788]

Hi Reza: Thank you for this very useful video.

[@RezaDorrani]

outputs('Get_files_(properties_only)')?['body/value']?['DocFunction']?['Value']

[@sueamin2788]

@@RezaDorrani Many many thanks!

[@yatinpurohit]

Useful tips, a must view for anyone creating Flows whether beginner or experienced. One problem I have in trouble shooting Flows is that I cannot customize a title or embed any meta-data for a flow run. For example, I would like the SharePoint item ID or a SharePoint item column value to appear in Flow run title and filter it, so that I can jump to the flow run quickly. Any tips?

[@RezaDorrani]

Currently, not possible to make a flow title or run with a dynamic name or tag. Tip would be to do error handling and notify admins of failed runs as shown here kzbin.info/www/bejne/boCZaWCZmJKEhNE

[@manoharreddy2577]

Thank you Reza.. very useful

[@RezaDorrani]

You're welcome 😊

[@MaruthachalamKrishnamurthy]

Thank you Rez... Great video and really helpful!

[@RezaDorrani]

Thanks for watching

[@ooditjethwa6254]

Wonderful overview covering all aspects

[@RezaDorrani]

Thank You!

[@ooditjethwa6254]

@@RezaDorrani Thanks to you! :D

[@maggieho9521]

Great video! Question: I created an app that calls a flow. The flow works for me perfect; generated pdf file in OneDrive and sent email. However, all other users ran the app. They got no error or message. The app just kept running, no pdf file generated and no email received. I checked the flow history. There's no record of the users ran the flow. Is there anywhere I can check what happened to the flow when users ran the app? Greatly appreciated your help/suggestions! Thanks.

[@RezaDorrani]

Not sure about your issue. If flow is not being called then it probably is some issue in the app action calling the flow. You may want to try and exit the app from a user who is facing the issue. And on click of button to call flow, you may see the error there in edit mode experience.

[@gauravk1987]

Hi Reza, Thank you for sharing such useful tips. Can you tell me how many times can I run a particular flow in a day if a user has free power automate subscription?

[@RezaDorrani]

It depends on license and api limits. I am covering this exact question this weekend. Join me live on Saturday July 31st at 11AM EST kzbin.info/www/bejne/e2i3aqufpc-LnKc

[@gauravk1987]

@@RezaDorrani look forward to it.

[@srai1471]

Hi Reza, Thanks a lot for this summarized video. It's a huge help. I have a question in relation to the Try-catch scope you have mentioned. The Filter Array Action in my catch block queries the result('Try') where Try is the name of my scope but I don't see any 'Status' variable in my dynamic content? Alternatively, I have also tried querying the output of my preceding Compose action but I still don't see the 'Status' variable appear in my dynamic content. Could you think of what's wrong here?

[@RezaDorrani]

Cannot think without looking at your flow in action. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@srai1471]

@@RezaDorrani thanks Reza, I'll give it a go.

[@vishnus4307]

Great video, thanks for sharing knowledge

[@RezaDorrani]

Thanks for watching!

[@shraddhamehta8707]

Thank You so much for your efforts

[@RezaDorrani]

It's my pleasure

[@gauravk1987]

Hi Reza, Thank you for this helpful video. My question is whenever a user account password is reset , the power automate flow running on that account starts failing and we have to reauthenticate. Is there any way to handle that? not sure if its a token issue. I read somewhere that we can turn off the expire token setting but couldn't find it.

[@RezaDorrani]

I am not sure about that. I have flows running with accounts that have their passwords reset multiple times. I will recommend checking on forums at powerusers.microsoft.com in case someone else has run into similar issue

[@aysanhaghani5271]

This is great! Thank you, Reza, Can you please direct me to the right video or source for the " Error handling in Power Automate flows" part? I really appreciate it

[@RezaDorrani]

Thank You. Check kzbin.info/www/bejne/inSso2p4mJiCodE

[@aysanhaghani5271]

@@RezaDorrani You are the best! thank you! that video was also great and helpful

[@RezaDorrani]

@@aysanhaghani5271 Wow. Thanks for the kind words.

[@DanielMoraisPRO]

Thanks for your awesome content Reza!

[@RezaDorrani]

My pleasure!

[@ivancuervo777]

Hello Reza, a suggestion, there is no easy tutorial for power automate on how to send rich text format emails (or with html), that can be an awesome video

[@RezaDorrani]

I have that in my backlog and will give it a higher priority. Thanks for the suggestion.

[@kelvinware875]

@@RezaDorrani I found the easiest way is to send a test mail formatted the way you want. Open the mail using the View Source option, paste into the mail function, then replace text using the data elements

[@RezaDorrani]

@@kelvinware875 That is also a great option.

[@RezaDorrani]

Here it is kzbin.info/www/bejne/jJ-6mGB7pN1mbbM

[@rickjameslynn]

excellent video. All helpful and well explained. Thanks!

[@RezaDorrani]

You're welcome!

[@sohansinghchauhan]

Great Video Reza, Can please suggest the best way if need to read more than 5000 records from the list how we can read, in the list have around 2 Lakh + records .. there is a filter not possible because need to check each and every item in another list those still exist or not. basically, this list combined information from multiple lists and regularly need to check the item exist in actual lit or not Thanks for the Video

[@RezaDorrani]

Flow has limits (API calls) - aka.ms/servicelimits I would not recommend flow in scenarios where you want to maintain 2 large lists in sync at all times. Use logic apps or some other mechanism.

[@sohansinghchauhan]

@@RezaDorrani Thanks for your response, if the number of users at the Tenant level more than 1000 + is still Power Automate will have an issue. I think Limit share at Tenant level Right. Please suggest.

[@RezaDorrani]

@@sohansinghchauhan API call limit is per user (flow running account) for a 24 hr period.

[@seshasai7348]

Thank you very much reza.

[@RezaDorrani]

Most welcome

[@hubertg1454]

Thank you, excellent summary

[@RezaDorrani]

Thanks Huber

[@arshad801]

Awesome job another gteat example of helping community

[@RezaDorrani]

Thank you Arshad