Showing results for 
Search instead for 
Did you mean: 
Super User
Super User

Discussions regarding the use of MS Flow vs Patch() Collect() with sharepoint lists.



When I was a year less experienced, I was using MS Flow for all of my new items and modifying items in Sharepoint.  For some reason, back in the day, I was in the belief that it was easier, and more reliable to have MS Flow perform these functions.  It was very graphical based, and easy to manage Sharepoint data with flow.


Now that I know more, I have some experience using Patch() and Collect() with collections in PA.  I have also started to venture into updating one of my SQL tables using Patch().  


I would be very interested to hear other's opionions on doing these functions directly in PA through these commands, or using Flow.  I do know that using the command structure is a bit more tedious, and it is harder to track issues as Flow has a very nice way of looking through a failed run to find problems, etc.  


Thanks in advance!  Please comment!!!

Resident Rockstar
Resident Rockstar

I have used both.  If what I am doing is associated with any type of UI such that I have to have PowerApps, then I use the PowerApps method and generally only invoke Flow for things there is not a way to do in PowerApps.  If what I am doing has no need for a UI, then I will just do it in Flow.  But that's just my personal preference.


Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Do you find that updating records in SP or SQL as reliable via Patch() in PA?

Helpful resources

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (1,538)