Answered

Patch with Power Apps

(0) Share

Report

Posted on by MJGreyling

161

Good day, I am new to power apps and it is giving me a headache. 🤕

I would like to update an item in a sharepoint list based on the value from a scanner input. I keep getting errors and I cannot figure out why:

Patch('PH Inventory SLOC checker', LookUp('PH Inventory SLOC checker',Title=BarcodeScanner1.Value), {SLOC: Dropdown2.SelectedText})

If I understand this correctly: Patch(List to be patched, Lookup the value in list column Title that equals tha value of barcodescanner1, update the column SLOC with the Selected text in dropdown2.)
I get these two errors no matter what I do:

Error 1:

Error 2:

PLEASE HELP ME!!!

Categories:

Building Power Apps

All responses (5)

Answers (2)

Sort by

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MJGreyling ,

May be below code will help.
Please check the Drodown2.SelectedText if it is giving value or not.

Patch('PH Inventory SLOC checker',LookUp('PH Inventory SLOC checker',Title=BarcodeScanner1.Value),{SLOC: Dropdown2.SelectedText.Value/YourRecordColumnName}) or UpdateIf('PH Inventory SLOC checker',ID=LookUp('PH Inventory SLOC checker',Title=BarcodeScanner1.Value).ID,{SLOC: Dropdown2.SelectedText.Value/YourRecordColumnName})

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.
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MJGreyling
Patch('PH Inventory SLOC checker', LookUp('PH Inventory SLOC checker',Title=BarcodeScanner1.Value), { SLOC: Dropdown2.Selected.Value } )
Verified answer

Pstork1 69,661 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

The SelectedText property of a dropdown is a record. YOu need to specify what value you want out of the record. Your code should probably use

Dropdown2.SelectedText.Value
MJGreyling 161 on at

Like
a
(0)

Report
Copy link

Link copied!

This did the trick. Thank you. At least I learned something new today! 😄
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@MJGreyling

Just to add a little to this for information...

SelectedText is a deprecated property that should be avoided in new apps. It used to be listed in the docs as deprecated, but now it no longer even appears in the docs. So, be ready for that time when apps become broken when the property is removed.