Unanswered

How can I get ID of created items using Patch() in a ForAll function? I cant invoke Set() inside ForAll()

(0) Share

Report

Posted on by DaynaBee

309

How can I get the ID of created items using Patch() in a ForAll function that goes through a collection? I can't invoke Set() inside ForAll(). I am trying to send an email for each item, with a deep link to a task screen.

ForAll(
 Collection, 
 Patch('List',Defaults('list'),
 {}
 )
)

@Pstork1 @SudeepGhatakNZ @WarrenBelz

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Yemata,

You could use the With() function instead to create a function scope variable:

ForAll( CollectionName, With( { wRecord: Patch( ListName, Defaults(ListName), {ColumnName: ColumnValue} ) }, //Referencing the record ID would be done via wRecord.ID //You can use this reference within e.g. the Office365Outlook.SendEmailV2()function wRecord.ID ) )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Pstork1 69,653 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

This is one of the spots where ForAll() proves that its not procedural. I would suggest calling a Power Automate Flow to create the items. Then you can easily have the flow create an array of the IDs and pass that back to Power Apps.

@LaurensM use of With should work if you want to use the ID in the For All, but if you actually want to save it somewhere, like a collection I don't think you can using just Power Apps

Was this reply helpful? Yes No
CarlosFigueira Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
ForAll(table, expression) returns a table with the result of the expression applied to each row of the table, so the result of your ForAll has all the records that had been inserted:

Set( myInsertedRecords, ForAll( Collection, Patch('List', Defaults('List'), {}) ) )

At that point you can use another ForAll to send an e-mail for each inserted record:

ForAll( myInsertedRecords, Office365Outlook.SendEmailV2( recipient, subject, $"<h1>New record inserted!</h1><p>Click <a href='https://contoso.org/items/{ThisRecord.ID}'>here</a> to access it!</p>" ) )

You can also do it in a single ForAll expression as well:

ForAll( Collection, With( { insertedRecord: Patch('List', Defaults('List'), {}) }, Office365Outlook.SendEmailV2( recipient, subject, $"<h1>New record inserted!</h1><p>Click <a href='https://contoso.org/items/{insertedRecord.ID}'>here</a> to access it!</p>" ) ) )

Hope this helps!

Was this reply helpful? Yes No