Using ForAll Function

(0) Share

Report

Posted on by JürgenD

166

Hello,

i have a sharepoint list with parcels that receivers should mark as received by using a link in an email. Of course not everybody does. So in a powerapp i have a datatable which is filtered to all parcels older than 30 days and not marked as received:

Sort(Filter(Paketeingangsliste;Erstellt < DateAdd(Today();-30);IsBlank(Abholer)=true);ID;Descending)

I would like to a have a button that marks all entries as received by clicking on it. That means to write a certain user (i.e. Müller Hans) in column "Abholer" which is of type person/contact for all entries in the datatable.

I think it's possible to do that with the ForAll-Function but i am not sure how.

Can you help me?

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

WiZey 3,023 Moderator on at

Like (0)

Report
Hello @JürgenD ,

The most optimal way is to combine "Patch()" and "ForAll()" to batch update a SharePoint list.

Patch( source; ShowColumns( collection; "ID" ); ForAll( collection; { column1: value1; column2: value2; ... } ) )

"ShowColumns()" return a table with every ID of the records you want to update. Be sure the ID match between the collection or the source, otherwise PowerApps may create new records instead of updating existing ones.

"ForAll()" then return a table with every column you want updated. The columns' names MUST match with the source, otherwise it may gives unexpected results.

Replace "collection" in my code with the list of all your unmarked items and it should work.

Hope this was helpful to you.

Was this reply helpful? Yes No
Verified answer

JürgenD 166 on at

Like (0)

Report

Hello @WiZey
thank you for your help.
But there is one thing, i don't understand:
When I put your code to the onselect-property of a button, how do i get the relation to the filtered list (see filter string at the beinning of the post)?

Was this reply helpful? Yes No