Unanswered

Selected.Value or Selected.Result not working (Form)

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi!

I am trying to show different cards based on the choice made in a dropdown card. The dropdown is based on a Sharepoint list with a choices column, where multiple choices can be selected. I would like a new field to show for each choice, but if I use the .Selected.Value or .Selected.Result function in the "Visible" property of one of the datacards I get an error:

The dropdown card has data type "Complex", I'm not sure if this makes a difference.

Does anyone know how to solve this? Or how to get my desired output?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

RJM07 801 on at

Like
a
(0)

Report
Copy link

Link copied!

Try Selectedtext.Value or SelectedText.Result (Whichever is applicable)

1 people found this reply helpful.

Was this reply helpful? Yes No
mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

So in general I avoid complex columns in my SP lists like the plague. They are harder to work with and complicate almost everything you use them in. I try to just code the 'choices' functionality into my app rather than use a choice column. For example if they can only create a new item in the SP from a single page in my app then I will just hardcode a dropdown to have ["option1","option2","option3",etc...] in my app and that means that those are the only 'choices' they have. Now I can be sure that my column in SP is still only one of the options I wanted it to be, however I can make that column type a string and working with strings is much easier.

When you want to multiselect this complicates my scenario and may force you to think outside the box a little. What I think is happening for you is that your combobox (dont think dropdowns can multiselect) is returning a table as the return type. This means that you cant just say .Value or .Result and expect a record or value from a record. Since you have a table as the return type you would have to specify which row/object you were referencing from that table before you used a dot operator to access its fields.

Table.Value may return [{object1},{object2},{object3},etc...}]
What you are trying to do is say object.Value but what you are actually saying is the table/array.value ([].value) which Power Apps doesnt know what to do with as there could be multiple rows available in that table. Even if the table has only 1 row/object it will still return a table type btw.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you both @mmollet @RJM07 for your replies! I found out that I used the wrong reference, I referred to the DataCard and not the DataCardValue. 😅 Everything seems to work now.

Thank you @mmollet for your thorough explanation, I will definitely keep this in mind.

Was this reply helpful? Yes No