Answered

Sort of distinct

(0) Share

Report

Posted on by Coopedup

347

I have a drop down which displays a SP List person column based upon the user type in another drop down (admin, owner etc.). The problem is that despite no errors, then sort makes no difference.

Can anyone advise?

 Dropdown1.Selected.Value = "Owner",
 Sort(ForAll(Distinct(
 'SP Register'.'Owner',
 { 
 '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", 
 DisplayName:'Owner'.DisplayName,
 Claims:'Owner'.Claims, 
 Email:'Owner'.Email
 }
 ),Result), Ascending)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

v-albai-msft on at

Like (0)

Report

Hi @Coopedup ,

How do you get the user type? What is the returned data type from your another dropdown? (Is the second dropdown with static values like "Owner", "admin"?)

Can you please more information with your scenario for helping me undertand your requirement(better with screenshots)?

I cannot fully understand your formula(why you use Forall() function).

Best regards,

Allen

Was this reply helpful? Yes No
Coopedup 347 on at

Like (0)

Report
Hi Allen,

The fields I'm collecting names from are all SP List person or group fields and the "decision" drop down is a static value field as below. If I select "Owner" I'm getting a unique list of names from my SP list Owners field, which is great. Though the order seems to match last update and I'd like to make it alphabetical. As for using ForAll, no reason for it other than that's how I have it working and known no better! What I didn't make clear in the example code above is that this sits within an If statement with 2 other SP list fields based on select role. I hope this helps?

Thanks for taking your time to look.
[Blank(),"Owner", "Mitigation Owner", "Senior Sponsor"]

Was this reply helpful? Yes No
Verified answer

KvB1 1,596 on at

Like (0)

Report
I don't think you defined which column needs to be sorted to ascending.

Dropdown1.Selected.Value = "Owner", Sort(ForAll(Distinct( 'SP Register'.'Owner', { '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", DisplayName:'Owner'.DisplayName, Claims:'Owner'.Claims, Email:'Owner'.Email } ),Result), Result, Ascending)

Was this reply helpful? Yes No