Answered

OnChange stopped firing

(1) Share

Report

Posted on by Shane123

I have a Power App with a "Price" text input that allows certain users to update prices that are kept in a Sharepoint List. Once a user scans or looks up an item, they can change the price of the item within the gallery and the new price is also patched to the Sharepoint List. My code is below, with the collection and SP list names changed for clarity:

Patch(collection,ThisItem,{Price: Value(Self.Text)}); Patch('Sharepoint Price List',LookUp('Sharepoint Price List',Title=Gallery1.Selected.BarcodeInfo),{ItemPrice: Value(Self.Text)})

This seems to have started with Power Apps release 3.22022.31. It was working well before then. I appreciate any ideas to get this working!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

RodCha 216 on at

Like
a
(1)

Report
Copy link

Link copied!

This might be an option:
Patch(Collection, ThisItem, {Price: Value(Self.Text)});
Patch('Sharepoint Price List', LookUp('Sharepoint Price List', ID = ThisItem.ID)), {ItemPrice: Value(Self.Text)})

By the way that your formula looks, you are creating a 'Collection' when the app runs 'OnStart', in case you are not taking only specific columns from you SharePointList, otherwise the ID might not work.

P.S. is not necesary to add 'Gallery1.Selected.BarcodeInfo' in the formula since you are using it in your 'Gallery' when searching the item, instead use 'ThisItem.BarcodeInfo' but it can be more precise if you start using ID instead of anything else.
Shane123 9 on at

Like
a
(1)

Report
Copy link

Link copied!

This worked! Thanks @RodCha!
Harrilald1963 4 on at

Like
a
(1)

Report
Copy link

Link copied!

Resolver !!!!!

Thank you, thank, thank you.

After days of hair-tearing stress, I found your solution...Save me another sleepless night.