News and Announcements icon

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

Power Apps - Building Power Apps

Answered

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

(0) Share

Report

Report

Posted on by MIA27

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

All responses Img

All responses (2)

Answers Img

Answers (1)

MIA27 on at

Like (0)

Report

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

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

v-qiaqi@microsoft.com on at

Like (1)

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

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)