Let’s consider this scenario where you have a SharePoint List and you need to Bulk Edit the same which triggers a Flow.
How would you want to capture the record updates in Flow Runs – Individually? Or all in an Array?
Let’s see how this can be done!
SharePoint Trigger in Power Automate
Let’s see what trigger is being used on which I can choose to have Split On in case of Bulk Update of Item Changes.
- In Power Automate, you can search for SharePoint and you’ll find the trigger on which for Item Update in SharePoint.
- Now, since I have a List called 2021 Onboarding in my SharePoint in the Site called Data Store Internal
- And this Flow will be triggered whenever there’s an Update to the Items on the List I’ve mentioned above.
Let’s look at what options are available us to toggle between having Split On and Off and what the results are –
- Go to the Settings of the Trigger to access the Split On setting toggle.
- You’ll see the Split On is set to ON i.e. as per below –
- Given that this can be turned ON and OFF, we’ll look at the difference between the two results when you Bulk Edit SharePoint Items which will initiate this trigger.
Example: Split ON
Now, let’s review how having Split On will affect the results.
- Now, let’s see Flow Runs are recorded when Split On is set to ON and the Split is on Body/Value
- Now, when I modify multiple items in SharePoint, say, the Group Code field in my SP List as below –
- Then, there will be 2 different Flow Runs.
- Now, if you look at the results, the way these exist per Flow Run is as follows. And for each record, this is the case –
Example: Split OFF
Now, let’s review how having Split OFF will affect the results.
- Now, once the Split is OFF and you Bulk Edit the records.
- And when you Bulk Edit the List in SharePoint the same way as you did above,
- Only 1 Flow Run will be created as shown below –
- And, if you open the results, you’ll see the multiple items in the body – value (Array of each record as value in the body) which were modified.
Hope this was useful!
Here are some more Power Automate / SharePoint Online posts you might want to check –
- Admin Center URLs under M365 – Power Platform, Teams, SharePoint, Power BI
- AddColumns() function to dynamically add columns to a Data table in Canvas Power App | SharePoint List
- Launch URL on a Data Table Text column selection in a Canvas PowerApp | SharePoint Lists
- Search Rows (preview) Action in Dataverse connector in a Flow | Power Automate
- Advanced Lookup in Model-Driven Apps | Power Platform
- Suppress Workflow Header Information while sending back HTTP Response in a Flow | Power Automate
- Adaptive Cards for Teams to collect data from users using Power Automate | SharePoint Lists
- Aggregate functions in a Canvas Power App | Using on SharePoint Lists
- Save generated PDFs to SharePoint directly – 2020 Wave 1 | Early Access Feature
- D365 Ribbon Button shortcut to open a Document in SharePoint Online