Combining bulk update with "with" function possible?

(0) Share

Report

Posted on by HansHeintz

711

I would like to update several columns in a collection based on a record I need to lookup.

If I would lookup that record for every column it would be slow.

I would like to do something like

UpdateIf(

Mycollection

,true

,With(

{MyRec:Lookup(etc..)}

{

col1:MyRec.Field1

,col2:MyRec.Field2

}

)

The compiler sees this code as invalid.

If I use ForAll the compiler thinks it's ok and it works but all other column values in the collection are lost.

Probably simple but just don't see it right now.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Adrian_Celis 1,652 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @HansHeintz

You should have your 'With' formula outside of the 'UpdateIf'. Try this:

With({MyRec:LookUp(etc...)}, UpdateIf(MyCollection,true, {Title: MyRec.Field1, test1: MyRec.Field2}) )

Was this reply helpful? Yes No
HansHeintz 711 on at

Like
a
(0)

Report
Copy link

Link copied!

So in your example MyRec evaluates different for each item of MyCollection?

Was this reply helpful? Yes No
Adrian_Celis 1,652 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @HansHeintz

Oh, so MyRec is different for each item in MyCollection?

And does your MyCollection has an ID column?

If so, you can use ForAll + AddColumns first to map out your MyRec first, then do the UpdateIf. Something like:

ForAll(AddColumns(MyCollection,"myRec",LookUp(...)) As ActiveRecord, UpdateIf(MyCollection,ID = ActiveRecord.ID, {col1:ActiveRecord.myRec.Field1, col2:ActiveRecord.myRec.Field2 } ));

I'm not sure if this is better or worse, but this is the alternative I can think of.

Was this reply helpful? Yes No
HansHeintz 711 on at

Like
a
(0)

Report
Copy link

Link copied!

I have extensively used the adding of a record to the column of a collection but i find that powersapps randomly looses some columns of this record. If I try to retrieve the value of a field of this record in the app it is Blank() while in the original record it is not. Actually my first question stems from my frustrations of using the implementing a record in the collection method 😉

Was this reply helpful? Yes No