Answered

Dependent data card value based on dropdown selection...

(0) Share

Report

Posted on by MikeBS

I've run into an issue that involves dropdowns powered by an Excel data table with duplicate entries. When I add another dependent dropdown, it works fine, but when I try to add a data card to display definitions, I get a formula error indicating that PowerApps can't find the field name from my excel table. I will include photos of before and after I add the distinct formula for your review.

Both dropdowns are populating their respective data card labels below, but I have duplicates in the Major Loss Cause dropdown:

After adding the distinct formula, Distinct(Definitions,'Major Loss Cause '), to the data items property. the data card label has an error:

I understand that using "distinct" can limit delegation, but the other dropdown is working. What's the workaround?

Thanks,

Mike

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report

@MikeBS ,

That error appears to be on the text box below (not the drop-down). Can you please click on the "red X" and see what the error is there.

Was this reply helpful? Yes No
MikeBS 13 on at

Like (0)

Report

Yes, thanks for clarifying, Warren. The error is on the text box below and the screengrab I have of the error in the original post is related to that text box and posted below:

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

Like (0)

Report
@MikeBS ,

The issue is Distinct() produces a Table of all distinct value and a Text control needs a single text value (so you can only display the content of one of these records) - for the first item

First( Distinct( Definitions, 'Major Loss Cause' ) ).Value

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

Was this reply helpful? Yes No
MikeBS 13 on at

Like (0)

Report

I've updated the formula and it has generated the following error:

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,075 Most Valuable Professional on at

Like (1)

Report

@MikeBS ,

That was the code for the Default of the text box and you have put it back in the Items of the drop-down. I am getting a little lost here as the error is showing on the Text box, so what is the error on this ? it is saying 'MLC Definition' is not recognised, but you are referring to 'Major Loss Cause'. I also noticed your data source is Excel (sorry I did not notice before or probably would not have responded as the unexpected is normal when you use this). Do you have access to SharePoint Lists ?

Was this reply helpful? Yes No
MikeBS 13 on at

Like (0)

Report

I do. Should I load this into lists?

Was this reply helpful? Yes No
MikeBS 13 on at

Like (0)

Report

Switching to lists and adding your formula worked. Thanks so much!

Was this reply helpful? Yes No
MikeBS 13 on at

Like (0)

Report

Warren, I thought it was working, but the definition doesn't change based on the selection in the dropdown. It stays static to the first item in the list. What can I do?

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

Like (0)

Report

@MikeBS ,

Just to revisit this with the new code, what is not working now - please provide the code, where it is being used and the result.

Was this reply helpful? Yes No