Answered

Auto Populate Form Using Drop Down

(0) Share

Report

Posted on by BAER_Group

Hi all,

I'm looking to have a DataCard autopopulate from source data, using the selected value from another DataCard dropdown from within the same form. Specifically, have it so that the Customer Name selected on the drop down autopopulates that customer's correct Customer Postcode in the next DataCard.

Both DataCards are looking up the same source data file, an Excel table 'Enquiry_Tracker' (which contains the Customer Name and Customer Postcode columns) however the form upon submission will update a separate source data excel file.

Pictured here is the formula I've gone with, but as you can see by the error symbol, no luck.

I'm wondering how best to enable Customer Postcode to auto populate upon the selection of the customer name from the drop down which is pulling from the Enquiry tracker table?

Many thanks!

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

Bilakanti 1,226 on at

Like
a
(0)

Report
Copy link

Link copied!

@BAER_Group use the below code.
If(!IsBlank('Customer Name_DataCard5'.Selected),Lookup(Enquiry_Tracker, 'Customer Name' = Customer Name_DataCard5'.Selected.'Customer Name',' Customer Postcode')
BAER_Group 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @Bilakanti
I'm experiencing a new error message?
Any ideas?
Bilakanti 1,226 on at

Like
a
(0)

Report
Copy link

Link copied!

@BAER_Group can you show me what’s your data source and what is customer name column
BAER_Group 20 on at

Like
a
(0)

Report
Copy link

Link copied!

@Bilakanti here are the relevant columns in the data source, which is the table in an excel file called 'Enquiry_tracker'

Whilst I want the customer postcode DataCard in Power Apps to update with the information matching the customer name from this file, the form these DataCards are contained within will update a separate excel table upon submission.

Thanks very much for your help
Bilakanti 1,226 on at

Like
a
(0)

Report
Copy link

Link copied!

@BAER_Group Your datasource looks good to me then the formula should work for sure.
Verified answer

WarrenBelz 156,750 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@BAER_Group ,

Apart from missing a closing bracket on that code and a small u in LookUp, you can be a bit more specific as below

If( Len('Customer Name_DataCard5'.Selected.'Customer Name') > 0, LookUp( Enquiry_Tracker, 'Customer Name' = Customer Name_DataCard5'.Selected.'Customer Name' ).'Customer Postcode' )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps