Dropdown from form not pulling in existing data

(0) Share

Report

Posted on by bpansy4

I have a form users get to from separate screen that populates:

FormDemo

Item: If(EntryTypeVar="New", Defaults(tblMember), EntryTypeVar="Edit", MbrSearchResults.Selected)

11 of the 12 fields in the form, some text boxes some drop-downs, populate and pull in data from tblMember (for now excel based, eventually will be a sql table). However, I have one field a drop-down called Marital_Status that is blank. When I create a new entry, it writes it fine, I can exit the form, go back, and find the entry. However, for the 1,000 existing entries that have already been created, the drop-down appears empty.

DataCardValue10

Items: Distinct(tblMarritalStatus, Marital_Status) -- this works fine for new entries,

Default: Parent.Default

I have another drop-down in the same form referencing tblState, same exact set-up as above, and it pulls in previous entries and lets me create new ones without issue. There are no error warnings wither, so I'm baffled.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@bpansy4

Change your Items property on the DataCardValue10 to the following:

RenameColumns(Distinct(tblMarritalStatus, Marital_Status), "Result", "Value")

Since you are assigning the default from your Choice column, it will have a Value property for the actual value. Distinct returns a table with a Result column. So rename the column in the Items and the two should match then.

I hope this is helpful for you.

Was this reply helpful? Yes No
bpansy4 on at

Like (0)

Report
Copy link

Link copied!

First off, thanks for replying on New Years Eve!

Same result. Am I supposed to alter the "Result" / "Value" to something? I have a duplicate text box that pulls in the right data though.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@bpansy4

It was a quick answer...

Tell me more now about

1) the Marital_Status column in the tblMarritalStatus table in your Excel - does it have duplicate values (i.e. asking what you are using Distinct for).

2) the Default value on the DataCard that DataCardValue10 is in.

3) Please verify that you are using a DropDown and not a ComboBox.

Was this reply helpful? Yes No
bpansy4 on at

Like (0)

Report
Copy link

Link copied!

1) no dupes, it only has 10 distinct options, such as single, married, divorced, widowed, etc... I suppose the distinct part is redundant, it's just a force of habit
2) parent.default
3) confirmed it's a drop-down. It's part a form not a free-standing entity on the screen.

Was this reply helpful? Yes No
Verified answer

bpansy4 on at

Like (0)

Report
Copy link

Link copied!

I figured it out! The field had an extra space before and after each entry. Once I trimmed it, all the matches appeared. Talk about frustrating.

Was this reply helpful? Yes No