Skip to main content
Community site session details

Community site session details

Session Id : 45sD9De3YSaeBxYQiXpaMp
Power Automate - Building Flows
Answered

Wanting to update single item all matching items are updated.

Like (0) ShareShare
ReportReport
Posted on 2 Feb 2022 22:29:25 by

Completely lost here.  Thought this would be pretty basic.

 

Using Sharepoint List as an "Issue Tracker" from the Microsoft Lists feature.

 

When I tag an item Status "Completed" I want PA to go ahead and add the current date to a field "Closed".

I have tried several "When an item is created or modified" -> Condition Status=Changed ->True -> Update Item Closed = "Current Date"

And maybe I'm just not understanding things, but the PA script processes EVERY row in the list even though I have "ID" specified in the Update Item section.  So every item that has a status of "Completed" the closed field is updated to "Today".

 

Frustrating, probably just my understanding of it...

  • Community Power Platform Member Profile Picture
    on 08 Feb 2022 at 15:15:09
    Re: Wanting to update single item all matching items are updated.

    You are showing "ID: from trigger" but all I have is "ID" I assume this is from the trigger, but no matter, it is my only option.

    I did get this to work, I believe your use of nested conditions is what did it. 

     

    Thank you!

     

  • Verified answer
    v-LilyW-msft Profile Picture
    on 08 Feb 2022 at 09:41:43
    Re: Wanting to update single item all matching items are updated.

    Hi @Anonymous 

    Has your problem been solved? 

    Where does the ID in your Update item action come from? Is it from Trigger?

    I tried to reproduce your scenario but it works fine for me.

    This is my test list.

    vLilyWmsft_6-1644312557468.png

    Flow in details:

    vLilyWmsft_1-1644311770463.png

    vLilyWmsft_2-1644311838285.png

    vLilyWmsft_12-1644313243959.png

    vLilyWmsft_7-1644312764185.png

    vLilyWmsft_8-1644312818561.png

    Save and test the Flow.

    When the item Status is changed to "Completed", the current date will be added to "Closed".

    vLilyWmsft_11-1644312973988.pngvLilyWmsft_10-1644312942298.png

    Hope the content above may help you.

    Best Regards

    If my reply helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Loading complete