Answered

Extract Multi-Select Values From Choice Column in Sharepoint List Into Combo Box

(0) Share

Report

Posted on by sausage_lynx

I am trying to extract data from a Sharepoint List into a combo box. Specifically, data in a choice column with multi-select functionality. I am able to point to the data, but am unable to extract it from the table inside the entry. Attached is a screenshot of what is input, and the output showing a table that cannot be point to. Is there any way to extract this data, or do I need to recreate the list in a different way.

Some background.

I am trying to create an app that looks at the User().FullName, and compares it to a list, and fills a combobox with the entries from a multi-select box.

Thank you in advance.

Thanks,

Categories:

Building Power Apps

example.PNG

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

WarrenBelz 153,079 Most Valuable Professional on at

Like (1)

Report
Hi @sausage_lynx ,
What you are getting there is a Delegation warning that User().FullName is not Delegable.
Easily fixed - set a Variable at App OnStart
Set(vUserName,User().FullName)
then use
Filter( 'Sales Engineers', Title=vUserName ).Basin

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.

Was this reply helpful? Yes No
Verified answer

v-siky-msft on at

Like (1)

Report
Hi @sausage_lynx ,

Do you want to extract the multi-select choices value into combo box?

I agree with @WarrenBelz 's opinion, Use() function is not delegable in Filter function, but it still only returns a nested table, shown in your screenshots.
To work around your issue, please try this:
Set OnStart of App:

Set(vUserName,User().FullName)

Modify Items of Combo box:

First(Filter('Sales Engineers', Title=vUserName)).Basin

Test result:
Hope this helps.
Sik

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

Like (1)

Report

@v-siky-msft , thanks for confirming my post.
@sausage_lynx , please tag me if you need any further input on this.

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.

Was this reply helpful? Yes No
sausage_lynx 9 on at

Like (0)

Report

@WarrenBelz and @v-siky-msft ,

Thank you both so much. The solution works like a charm. You're absolute wizards. I really appreciate the help, more than I can say.

Thanks,

SL

Was this reply helpful? Yes No