patching the varaible with lookup

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

hi expert

is there a way to set a variable and patch the SP list with lookup

for example

i want to set variable to the below code:

Patch(
Forecast,
LookUp(Forecast, UniqueID=Value(DataCardValue174.Text)),

{
ApprovalStatus: "Approved",

})

desired code:

Set(varRecord,Patch(Forecast,varRecord,

LookUp(Forecast, UniqueID=Value(DataCardValue174.Text)),

{
ApprovalStatus: "Approved",

ActiveStatus: {Value: "Active"}))

but i am getiing error in this

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

BCBuizer 22,798 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Removed varRecord from the Patch statement and added a closing curly bracket:

Set(varRecord, Patch( Forecast, LookUp( Forecast, UniqueID=Value(DataCardValue174.Text) ), { ApprovalStatus: "Approved", ActiveStatus: {Value: "Active"} } ) )

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Anonymous

If you already have the record and the primary key...why look it up again??

Please consider changing your Formula to the following:

Set(varRecord, Patch(Forecast, {UniqueID=Coalesce(varRecord.UniqueID, Value(DataCardValue174.Text)), ApprovalStatus: "Approved", ActiveStatus: {Value: "Active"} ) ) )

The above assumes that UniqueID is your primary key. If not, then change as needed.

I hope this is helpful for you.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

Just keep in mind with that formula you chose - that you are hitting your datasource twice. So, if performance is not a concern, then use it. Otherwise consider using the value that you have already gone to the datasource for before.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

i tried using that but its giving an error and yes unique id is primary key

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

Then you appear to be using Dataverse. The error in this case is because the Coalesce is trying to coalesce between a value of the Text input and a record.

That should be simply adjusted to account for the proper types. Coalesce has to coalesce between the same types.

Was this reply helpful? Yes No