Unanswered

Collection for FirstN UpdateIf For input Value

(0) Share

Report

Posted on by Aliah

Hai, need help… I’m create collection where auto generate 14 rows. Since that cannot merge row for text input “location” such as from row 1 to row 7, how can i auto populate text input when user insert text value in “location” from row 1 until row 7 will be same value? This I’m stuck on this one.

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Aliah ,

Assuming you have the ID of the item in the collection (if not use whatever unique identifier you have)

With( { _Data: FirstN( colPDR1Red7, 7 ) }, ForAll( _Data As _D, Patch( colPDR1Red7, LookUp( colPDR1Red7, ID = _D.ID ), {Memory: Self.Text} ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Aliah 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. First time using With function. At first I using UpdateIf coded ID one by one.
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Aliah ,

It is a bit of a sneaky workaround as you cannot update a data source with itself (you will get an error if you try), however With() effectively creates a "ghost copy" of the data you want to Patch and then the ForAll loops through this copy and updates the matching record in the "real" data source.
Aliah 6 on at

Like
a
(0)

Report
Copy link

Link copied!
I try to implement same way if ID =1 until ID =7 same text input value & another ID=8 until ID 14 same text input value. I'm not sure is correct or not:

With( { Data_Red: FirstN( colPDR1Red, 7 ) }, ForAll( Data_Red As _D, Patch( colPDR1Red, LookUp( colPDR1Red, ItemNo = _D.ItemNo ), {Location: Value(Self.Text) } ) ) ); With( { Data_Red1: LastN( colPDR1Red, 7 ) }, ForAll( Data_Red1 As _D1, Patch( colPDR1Red, LookUp( colPDR1Red, ItemNo = _D1.ItemNo ), {Location: Value(Self.Text) } ) ) );
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Aliah ,

Why bother doing 2 patches - just patch the first 14. I also assume here that ItemNo is a numeric column and is unique for each record.