Update dataverse column value based on in app lookup value

(0) Share

Report

Posted on by feiged

I’m very new to this environment and have spent a lot of time trying to search this online…. Time to ask for help!

I have a column in a power app that looks up a value from a secondary dataverse table inside a canvas app

(essentially, the text field of the datacard says “look in the PO table, and if the PO # on this item = the PO # in the PO Table, return the Vendor Name)

This correctly returns this value to the VIEW screen in the canvas app.

Where I am struggling is to get that data to write back to the original dataverse table.

Lookup formula: LookUp(SQL_POM_iERP90_ACEs, ThisItem.'SCAR PO #' = POM_PurchOrderID, POM_VendorName)

Trying to provide any applicable screenshots that may help:

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Ethan_009 4,838 Moderator on at

Like (0)

Report

Hi @feiged ,

Have you tried SubmitForm() function for the changes on the Form to be patched?

Was this reply helpful? Yes No
feiged 10 on at

Like (0)

Report

Onselect is set as:

SubmitForm('NCR Edit Form');Refresh('NCR Datasets');Navigate('NCR Home Screen');Notify("Save Successful", NotificationType.Success, 4000)

Was this reply helpful? Yes No
Verified answer

Ethan_009 4,838 Moderator on at

Like (0)

Report
Hi @feiged ,

As per screenshot,
Please attach the data to respective datafield (that's your logical column name)
and also, set the value in Default property

Then when you click OnSelect of submit button, use this
IfError( SubmitForm('NCR Edit Form'); , Notify("Error in Saving Record", NotificationType.Error, 2000); false; , Notify("Save Successful", NotificationType.Success, 4000); Refresh('NCR Datasets'); Navigate('NCR Home Screen'); true; );

Hope this helps

Was this reply helpful? Yes No
feiged 10 on at

Like (0)

Report

You make it seem so easy! Oh wait..., it is when you match up the right fields!
THANK YOU SO MUCH!!!

Was this reply helpful? Yes No