Combine individual flow runs into one run Sharepoint Get changes

(0) Share

Report

Posted on by debarbanson

187

Hi all,

I have the following flow setup which is running perfectly fine:

Screenshot 2022-11-03 at 10.05.36.png

Scenario as follows: Changes are made to a Sharepoint List item where I track the changes for the column Status. I pick up the previous value and the new value and send an email to the user that a status has changed. Detailed screens below:
Screenshot 2022-11-03 at 10.08.15.png

Screenshot 2022-11-03 at 10.08.54.png Screenshot 2022-11-03 at 10.09.41.png Screenshot 2022-11-03 at 10.10.16.png

So far so good. The changes in the status column are triggered by a new csv file which gets uploaded 8 times a day (by replacing the previous file). The file contains on average like 50 records.

The flow runs perfectly fine and if let's say 5 out of those 50 records have a changed status, 5 emails are send.

However if I look at the run results, I notice that for each and every record a separate run is started (ignore the first row, there I manually changed just one status in Sharepoint).
Screenshot 2022-11-03 at 10.13.47.png

I would assume that it should be possible to have just one flow run instead of separate record runs.
Anyone has an idea how to achieve this?

Many thanks in advance.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @debarbanson

Not really sure this would in your case. But try this:

Go to the settings of when an item or file is modified and close the option of split on.
So what split on does is, it creates separate flow runs. If you off it, all the files/items would be included in a single flow run.

Was this reply helpful? Yes No
debarbanson 187 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Sundeep_Malik ,
Many thanks for reaching out and based on your description this feels like exactly what I was looking for!
I have tried this, which of course alters the flow in a way that more for each loops are created.
I am struggling with the following and provide pictures to hopefully make it as clear as possible.
First 2 steps are now as follows:

Then I hit the Send an HTTP request. That's where I now struggle to get the versionID picked up. The code I used before is not working anymore:
_api/Web/Lists/getByTitle('OrderStatus')/Items(@{triggerOutputs()?['body/ID']})/Versions(@{outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/SinceVersionId']})

I have tried to change this into:
_api/Web/Lists/getByTitle('OrderStatus')/Items(@{items('Apply_to_each')?['ID']})/Versions(@{Items('Apply_to_each')?['body/SinceVersionId']})
but that does not seem to work. The flow will run but in the output of Send an HTTP request I can see that the VersionId number is not picked up, it shows Versions()
Do you have an idea how I can change the code in the Send HTTP request to Sharepoint so it does pickup the VersionId?

Was this reply helpful? Yes No