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