Create a collection from multi choice record

(0) Share

Report

Posted on by SimpleUser

Hello,

i'm trying to create a collection from an SP list multi choice column.

I need to lookup an employees name and then create a collection of multiple selected items within the 'Category' multi choice column record. Currently if i do it, the collection is a nested table with one row and then all the values in that. I need them all as their own values to create a lookup to it.

ClearCollect(colLicenseInfo,Distinct(Filter(SPList,Employee.DisplayName=DataCardValue21.Selected.DisplayName),Category))

Help appreciated

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report
Hi @SimpleUser

Try this

ClearCollect( colLicenseInfo,
AddColumns(
Filter(
SPList, Employee.DisplayName = DataCardValue21.Selected.DisplayName ),
"CategorySplit",
Split(Category, "; ")
)
)

It is worth noting that the Split function assumes that the values in the multi-choice column are separated by a semicolon and a space ("; "). If your values are separated by a different character, you will need to modify the formula accordingly.

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
SimpleUser 78 on at

Like (0)

Report

Hi,

its a choice column so they're not separated by anything. the split part of the formula return an error as the values aren't text?

Was this reply helpful? Yes No