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:
You make it seem so easy! Oh wait..., it is when you match up the right fields!
THANK YOU SO MUCH!!!
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
Onselect is set as:
SubmitForm('NCR Edit Form');Refresh('NCR Datasets');Navigate('NCR Home Screen');Notify("Save Successful", NotificationType.Success, 4000)
mmbr1606
22
Super User 2025 Season 1
stampcoin
17
Michael E. Gernaey
15
Super User 2025 Season 1