Unable to Patch Dataverse Table

(0) Share

Report

Posted on by iwonder

1,142

Thank you for taking the time to read my question.

I have the following code that runs (without errors from what I can tell), but when I refresh the data in Excel of my Dataverse table, the value I'm trying to update, is not changed. I also made a Gallery filtered to the record I'm trying to update and the price does not change in the Gallery either.

ForAll(
 galUpdatePrices.AllItems As galItems,
 If(
 IsBlank(
 LookUp(
 PriceLists,
 And(
 PriceListCode = galItems.cra98_PriceListCode,
 ItemCode = galItems.cra98_ItemCode
 )
 )
 ),
 Patch(PriceLists,Defaults(PriceLists),{Price:Value(galItems.cra98_Price)}),
 Patch(PriceLists,LookUp(PriceLists,And(PriceListCode = galItems.cra98_PriceListCode,ItemCode = galItems.cra98_ItemCode),{Price:Value(galItems.cra98_Price)}))
 )
);

//Patch(PriceLists,LookUp(PriceLists,And(PriceListCode = "42ABCFS",ItemCode = "10876045"),{Price:Value("7450.00")}))

I also tried just simply running the Patch() statement and nothing changed in my table either. I really don't know what I'm doing wrong!

Here is my Dataverse table:

any help would be great!

Thanks all,

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,224 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @iwonder ,

I am not a Dataverse user, but try the below with your unique identifier (I believe GUID) where I have ID

ForAll( galUpdatePrices.AllItems As galItems, With( { wItem: LookUp( PriceLists, PriceListCode = galItems.cra98_PriceListCode && ItemCode = galItems.cra98_ItemCode ) ) ), Patch( PriceLists, If( IsBlank(galItems.ID), Defaults(PriceLists), {ID:galItems.ID} ), {Price:Value(galItems.cra98_Price)} ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
iwonder 1,142 on at

Like (0)

Report
Copy link

Link copied!
Hi Warren,

Thank you for a great suggestion!

I took your idea and applied it this way and it worked!

Thanks

ForAll( galUpdatePrices.AllItems As galItems, With( { TheID: LookUp( PriceLists, And( PriceListCode = galItems.cra98_PriceListCode, ItemCode = galItems.cra98_ItemCode ), PriceLists ) }, Patch( PriceLists, If( IsBlank(TheID), Defaults(PriceLists), {PriceLists: TheID} ), {Price: Value(galItems.cra98_Price)} ) ) )

Was this reply helpful? Yes No