Answered

Condition Flow using the item modified user with the Multiselect Person type column

(0) Share

Report

Posted on by Danny_Dicaprio

Hi Everyone

I need to create a Power Automate flow that checks if a modified item in a SharePoint list was modified by a user listed in the "Risk Owner" column (which is a multi-select person type column), or LT owner column (which is a multi-select person type column), and then updates the "Last Update" column (Single Line of text ) with the current date if the condition is met, (like "Last Update 20 days ago)

Below I have shared the flow which I am working on

Could anyone please direct me How to do this

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Danny_Dicaprio ,

Please check this test:

My SharePoint List:

My Flow:

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (0)

Report
Copy link

Link copied!

@v-yetonggu-msft

Thanks for the reply.

Sorry if I didn't explain properly; you have misunderstood my requirement.

I want to check if a modified item in a SharePoint list was modified by a user listed in the "Risk Owner" column or the "Lt Owner" column.
If the list was modified by the users in either of those columns, I want to update the "Last Update" column.

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Danny_Dicaprio ,

Ok,thank you for re-explaining, I think I've understood what you mean, please see the following test:

There is something wrong with your flow logic, your trigger is to fire when an item is created or modified, and then update the item, which will trigger the flow again, falling into an infinite loop.

I have a link to an article here that can help you solve this problem, please watch it and make the corresponding settings in the SharePoint list.

Stopping Infinite Loops When Updating SharePoint List Items – Scott J Shearer – M365 and Power Platform Solutions (o365scott.blog)

After you set it up, please configure your flow according to my reference flow.

My Flow Overall Preview:

My Flow Configuration Parameters:

@equals(triggerBody()?['StopRun'],null)

union(variables('Emails'),variables('Emails'))

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (0)

Report
Copy link

Link copied!

@v-yetonggu-msft

Thanks for the reply. It worked perfectly well. I really appreciate your help with this.

I have one doubt: will turning on "Allow management of content types" affect the PowerApps forms in any way, such as the details being submitted from PowerApps to the SharePoint list?

I also had a similar issue with an infinite loop in a flow.
When an item is created or modified in my SharePoint list, I am running a flow to stop giving permissions and assign permissions based on the users. Currently, the flow is running in an infinite loop.

I have made the above changes in the SP list using the 'Stop Run' option. Could you please look at the flow below and check if I should add any further actions?

My flow is also getting failed, if the user column is blank

Could you please help me to fix this

Was this reply helpful? Yes No