Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Answered

Update dataverse column value based on in app lookup value

(0) ShareShare
ReportReport
Posted on by 10

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:

feiged_0-1684328790346.png

 

 

feiged_1-1684328790348.png

 

 

feiged_2-1684328790349.png

 

 

feiged_3-1684328790350.png

 

Categories:
  • feiged Profile Picture
    10 on at
    Re: Update dataverse column value based on in app lookup value

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

    THANK YOU SO MUCH!!!

  • Verified answer
    Ethan_009 Profile Picture
    4,838 Super User 2025 Season 1 on at
    Re: Update dataverse column value based on in app lookup value

    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

  • feiged Profile Picture
    10 on at
    Re: Update dataverse column value based on in app lookup value

    Onselect is set as:

     

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

  • Ethan_009 Profile Picture
    4,838 Super User 2025 Season 1 on at
    Re: Update dataverse column value based on in app lookup value

    Hi @feiged ,

     

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 17

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 15 Super User 2025 Season 1

Overall leaderboard

Featured topics