Drop-down List

(0) Share

Report

Posted on by Ali_sam

125

Hi. I have a application which has a drop-down. Connected with a SharePoint list.

It has a 8 9 values .

I used this below code in item of drop-down

ForAll(Distinct(Filter('CT_Personas Matrix', Role=DataCardValue11.Selected.Result).OL1, OL1),fResult:ThisRecord.Value])

Now how to set a specific value like Global on top. As you can see in the image. Like global at bottom. How to make it on the top .

Rest random.

Please help anyone if aware

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Ami K 15,687 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Ali_sam - below is a basic example, but I do not quite understand your syntax. Could you confirm what you have in the Items property of DataCardValue11?

Sort( Ungroup( Table( { DropdownOptions: Distinct( 'CT_Personas Matrix', Role = DataCardValue11.Selected.Result ) }, {DropdownOptions: ["#Global"]} ), "DropdownOptions" ), Value )

Was this reply helpful? Yes No
Ali_sam 125 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Amik . Thanx for your reply
I attached the list screenshot below
Dropdown11 value contains role. What we will select in dropdown 11 as role. Respective to that value will come in the next dropdown. That's what i filtered.

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Ali_sam sorry I do not understand your response.

Please could you answer my earlier question and I may be able to provide some support.

Was this reply helpful? Yes No
Ali_sam 125 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Amik

In Items property of dropdown 11 is : -
ForAll(Distinct('CT_Personas Matrix', Role), {Result: ThisRecord.Value}).

I hope this was your question & it's clear to you now.

Was this reply helpful? Yes No
Ali_sam 125 on at

Like
a
(0)

Report
Copy link

Link copied!

Please reply if you have any other query.

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Ali_sam please change the Items property of DataCardValue11 to:

Sort( Distinct( 'CT_Personas Matrix', Role ), Value, SortOrder.Ascending )

For the dropdown control you want to include "Global" onto, use:

Sort( Ungroup( Table( { DropdownOptions: Distinct( Filter( 'CT_Personas Matrix', Role = DataCardValue11.Selected.Value ), 'The name of the field you want to display' ) }, {DropdownOptions: ["#Global"]} ), "DropdownOptions" ), Value )

Was this reply helpful? Yes No