Fill Drop-Down List from Table2 Column and store the selected value in Table1 Column

(0) Share

Report

Posted on by KnowledgeSeeker

Hi community,

I am new to Power Apps, I tried to create a Canvas App based on the below Excel file which I have to OneDrive

post001_excel content.png

(the excel file has two sheets, Details which displays the current location of an agent, and City which will be used to edit that location)

I connected the both tables to Power Apps

post001_connected tables.png

The problem I am facing is that I get empty values when I change the DataCard type (Details-city) to Drop Down list

I tried connecting the drop down to the second table which contains the list of all possible cities but I got another error, I think I am stuck in a closed loop.

Any suggestions are welcome.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Hi @KnowledgeSeeker ,
I assume the DataCard of the drop-down is bound to the data field you want to see?
Change the Default of the DropDown to Parent.Default

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.

Was this reply helpful? Yes No
KnowledgeSeeker 21 on at

Like (0)

Report

Hi @WarrenBelz,
First of all thank you for your reply.
Actually the Default of the Drop Down is already set to Parent.Default

Thank you in advance.

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Hi @KnowledgeSeeker ,
What is the DataSource of the card - it should display that

Was this reply helpful? Yes No
Verified answer

KnowledgeSeeker 21 on at

Like (0)

Report

Hi @WarrenBelz,
The card is using the column City from the first table.

I solved the problem by replacing the default card by a new Drop Down instead of just replacing it from the fields properties.
After that I edited the formulas and it worked for both, displaying all cities from the 2nd Table and storing the selected one in the 1st Table.

Thank you.

Was this reply helpful? Yes No