web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Concat Choic Multi Sel...
Power Apps
Answered

Concat Choic Multi Select In Gallery with a DropDown Selection

(0) ShareShare
ReportReport
Posted on by 643

I have a Gallery that has worked assigned label, however I have a SP list that allows multi user selection. I have tried editing the lable to use the follwoing:

 

Concat(ThisItem.'Assigned To',value,",") which would work normally, however I also have a dropdwon and search function on my gallery, using this: 

 

If(!IsBlank(WTRFTOOLSEARCH.Text),Filter('WTRF Database',Find(WTRFTOOLSEARCH.Text,'Tool Number'.Value)),Filter('WTRF Database','Assigned To'.Value=WTRFASSIGNEDDROPDOWN.Selected.Value))

 

The dropdown is to filter by the Assigned to Property however since i changed it to multi it has broken. Assuming because of the concat function. 

 

jamescosten_0-1706786929090.png

All other labels have this error which i assume is linked to the Concat.

 

jamescosten_1-1706786969122.png

My general requirement is to allow multi users to be assigned the same job and log hours against it, and this WIP list needs filtering to individuals to allow them to see the work required. So on an itme with 3 people assigned I want it to show on all three of the peoples WIP list.

Categories:
I have the same question (1)
  • jamescosten Profile Picture
    643 on at

    I have been tinkering and have got it to the following:

     

    2024_02_01_15_45_44_Power_Apps.png

     

    Any Ideas on what can be done to have them match?

     

  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    on at

    HI @jamescosten,

    Every time you want to refer to a Choice column, you should refer to 'Assigned To'.Value

    Further more, to cmpare a multi select choice column with combobox selected item(not sure if it allows multi select or not), we have different format to go.

     

    Please check this thread for reference:

    Solved: Filter multiple selection choice column - Power Platform Community (microsoft.com)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard