web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Patch Collection using...
Power Apps
Unanswered

Patch Collection using a table coming from a Power automate response

(0) ShareShare
ReportReport
Posted on by

I have a Power Automate that returns a table whose corresponding json structure is :
[
{
"ID": "66747a09-1457-ee11-be6f-000d3ab1b2d7",
"Date": "23/01/2024 09:27",
"Status": "201"
}
]

There is a collection who has a similar structure. 
I would like to update the status of the collection with the value coming from Power Automate
I tried the following code

ForAll(
    Flow_result;
    Patch(Collection;
        LookUp(Collection ; ThisRecord.ID=ID);
        {'Status':ThisRecord.'Status'}
    )
);;

But I get only the first line updated ....
Can you help me pls?

Categories:
I have the same question (0)
  • plarrue Profile Picture
    Microsoft Employee on at

    Hi @thebruuu ,

     

    I believe it is because the Lookup function, In your case, I would say it's only updating the first record because of this.
    "The LookUp function finds the first record in a table that satisfies a formula. Use LookUp to find a single record that matches one or more criteria."

    Filter, Search, and LookUp functions (contains video) - Power Platform | Microsoft Learn

    Regards,
    Philippe

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 85

#2
WarrenBelz Profile Picture

WarrenBelz 76 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard