Update an list of Sharepoint item if a criterion is met

(0) Share

Report

Posted on by gavinleung

216

Hi all,

I in fact raised the same question a while, it solved my issue. But when my PowerApps deployment going more massively, and the records size is getting larger. This corresponding flow seems too slow and creates some issues. So I need further help.

I have a Sharepoint List with the following fields:

Flow cap.png

The Regular Meeting happens nearly everyday, and all members will be joining. In my original design, the user update the record using PowerApps, and a flow triggered by "an item is created or modified" to update the Actual Hours for all members. But issue comes as this will create a ETAG error, ie updating the same record by two sources.

Therefore, I'd like to change the design to delay the update from Flow by using Scheduled as attached:

Flow cap.png

This filter query works well to narrow down the records for "today" and with a specific title.

In the case that one of any members updated the Actual Minutes by the PowerApp, I'd like to have the Flow to update the Actual Minutes for the other members as scheduled.

Flow cap.png

How to get the item which has a value in Actual Minutes and update this value into the same field of the other records ?

Thanks,
Gavin

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-bacao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @gavinleung ,

If you want to filter out items whose values are actually in Actual Minutes field, you can still use Filter Query and add the following condition.

Like:

ActualMinutes ne null

Best Regards,

Was this reply helpful? Yes No
gavinleung 216 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @v-bacao-msft , my question was not how to filter the list.

In my first Get Items, I used:
Title eq 'xxxxxxx' and AssignmentDate eq 'utcNow('yyyy-MM-dd')'
This shall filter a set of records which containing this:
Then I'd like to do is to use the "Actual Minutes" of one of the records and update it into the other records of this set.

Can it be done ?

Thanks,
Gavin

Was this reply helpful? Yes No
Verified answer

gavinleung 216 on at

Like
a
(0)

Report
Copy link

Link copied!

I have the solution. I used a variable to temporarily store the value of the actual minutes first. Then use a loop to update the records which does not contain a value. I don't know whether it's stupid ... but it works:

Was this reply helpful? Yes No