Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Power Apps Pro Dev & ISV
Answered

Filtered Column isn't grabbing multiple values

(0) ShareShare
ReportReport
Posted on by 15
I have a multiselect combo box, that allows users to select multiple companies.  The combo box pulls its data from an external source (SharePoint list/lookup)Part1.PNG
I've created a HIDDEN single line text field that is auto populated with the ID numbers from the users choice above in the combo box  
My problem is it only grabs the first ID... and I need it to grab each ID from the (potentially) multiple selections.Part2.PNG

 

any help would be appreciated.

 

 

 

  • Verified answer
    ideaguy1974 Profile Picture
    15 on at
    Re: Filtered Column isn't grabbing multiple values

    Referencing the ID column from my Companies List wasn't possible (or at least it wasn't an option).  SO I created a single line text column called ID for Workflow, and when a new item is created in the company folder, a workflow copies the ID and puts it in the new column.

     

    I have a hidden text field that concatenates the companies that are selected in the drop down... its just a text field and it grabs the title text from the dropdown.

     

    I did the exact same thing, but referenced the new STUPID GD ID field that i had to create... I have solved my own problem by creating redundant columns and stupid workflows.  FU POWER APPs.

     

     

    ideaguy1974_0-1637591844393.png

     

  • ideaguy1974 Profile Picture
    15 on at
    Re: Filtered Column isn't grabbing multiple values

    Unfortunately that still only gives me a single value...

    image (1).png

    I'm going to try concat with your solution and see where that gets me.

  • v-bofeng-msft Profile Picture
    on at
    Re: Filtered Column isn't grabbing multiple values

    Hi @ideaguy1974 :

    Please try:

     

    Filter(Companies,ID in cbCompaines.SelectedItems.ID)

     

    Best Regards,

    Bof

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Power Apps Pro Dev & ISV

#1
WarrenBelz Profile Picture

WarrenBelz 94 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 72 Super User 2025 Season 1

#3
mmbr1606 Profile Picture

mmbr1606 71 Super User 2025 Season 1

Overall leaderboard