Unanswered

Adding an item to a drop down list

(0) Share

Report

Posted on by CU06081219-0

Hi,

I'm struggling with something really simple but I just keep getting errors. I have a power app with a drop down list to select a person in the team, the drop down list is linked to a sharepoint group. I want to add an option of "Unknown" without adding it to the sharepoint group. I've tried a few things in the code but nothing is working. The code for Items is:

Sort(
    ForAll(
        Filter(
            Office365Groups.ListGroupMembers("**sharepoint group**").value,
            Or( 
            "@gmail.com" in mail,
            "@gmail.de" in mail
            )
        ),
        { 
         Claims:"i:0#.f|membership|" & Lower(mail), 
         Department: "", 
         DisplayName: displayName, 
         Email: mail, 
         JobTitle: "", 
         Picture: ""
        }
    ),
DisplayName)
 
What do I need to add to this code to make it work?
Thanks for any help

Categories:

Power Query

I have the same question (0)

All responses (4)

Answers (0)

Infamous_Let 330 on at

Like (0)

Report
To add an “Unknown” option without touching your SharePoint group, you just need to append a manual record to your list. The trick is using Table(...) & Table(...) to combine your existing results with the extra one you want.

Sort( Table( ForAll( Filter( Office365Groups.ListGroupMembers("**sharepoint group**").value, Or( "@gmail.com" in mail, "@gmail.de" in mail ) ), { Claims: "i:0#.f|membership|" & Lower(mail), Department: "", DisplayName: displayName, Email: mail, JobTitle: "", Picture: "" } ) ) & Table( { Claims: "", Department: "", DisplayName: "Unknown", Email: "", JobTitle: "", Picture: "" } ), DisplayName )

This adds “Unknown” as another selectable option in the dropdown, and it’ll show up alphabetically.

Was this reply helpful? Yes No
CU06081219-0 8 on at

Like (0)

Report

Thank you, I have tried this but have an error

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

Like (1)

Report
Hi @CU06081219-0,

Firstly, you cannot use ListGroupMembers with a SharePoint Group - it needs to be an Office365 group, This should work with the Id of that group type. Please note in particular the Case sensitivity of displayName.
Sort( Table( Filter( Office365Groups.ListGroupMembers("Office365GrpupId").value, Or( "@gmail.com" in mail, "@gmail.de" in mail ) ), { displayName: "Unknown", mail: Blank() } ), displayName )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

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

Like (0)

Report

Hi @CU06081219-0,

A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No