web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to update the reco...

Power Apps

Answered

How to update the records of Edit Form Based on dropdown Selection

(0) Share

Report

Report

Posted on by MIA27

2

I have made a screen and open directly - Inserted Edit form to it (to view, edit and add records). It is working fine

till the EditForm datasource = Last(TblInvA)

But if Change the record source and try to select the record based on the Item selected in the drop down, it produces error

DataSource Dlookup(TblInvA, FormNo = FormNoDropDown.Selected.Value)

Please guide, it the method applied is wrong or code correction is required

My Sharepoint list has that column

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @MIA27,

Could you please tell me that what is the Dlookup function?

Power Apps only supports LookUp():

Filter, Search, and LookUp functions in Power Apps (contains video) - Power Platform | Microsoft Learn

Try:

LookUp(TblInvA, FormNo = FormNoDropDown.Selected.Value)

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your reply.

Actually DLookup is used to fetch data from Table/Domain/List in MS access programming.
The project I am working on is to move the database from MS-Access to PowerApp.
Learning new things along with mistakes (got confused as Lookup and Dlookup both exist in MS-Access programming).

I did some minor changes in your advised code and it worked:
LookUp(TblInvA,ID=FormNoDropDown.Selected.FormNo)

Upon change in the dropdown the edit form records get updated accordingly.

Was this reply helpful? Yes No

Join the conversation