Skip to main content

Notifications

Power Automate - General Discussion
Answered

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

(0) ShareShare
ReportReport
Posted on by

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 

 

Danny_Dicaprio_0-1716460594023.png

 

 Could anyone please direct me How to do this 

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

    @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?

    Danny_Dicaprio_0-1716538457536.png

     

    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?

     

     

     

    Danny_Dicaprio_0-1716538740718.png

     

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

     

    Could you please help me to fix this 

  • Verified answer
    Re: Condition Flow using the item modified user with the Multiselect Person type column

    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:

    vyetonggumsft_0-1716529583541.png

    My Flow Configuration Parameters:

    vyetonggumsft_5-1716530105949.png

    vyetonggumsft_7-1716530138076.png

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

    vyetonggumsft_2-1716529717212.png

    vyetonggumsft_3-1716529896263.png

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

    vyetonggumsft_4-1716530041571.png

    Best Regards,

    Sunshine Gu

     

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

    @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.

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

    Hi @Danny_Dicaprio ,

    Please check this test:

    My SharePoint List:

    vyetonggumsft_2-1716514733654.png

    My Flow:

    vyetonggumsft_0-1716514643758.png

    vyetonggumsft_1-1716514685832.png

    Best Regards,

    Sunshine Gu

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard