Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Compare Text to a Choice Column


I'm having issues with a particular formula where I want to filter a Sharepoint text column based on a another Sharepoint list choice column.

What i'm trying to achieve is simply to display data that concerns the user. Im my example below, a user can have multiple choices, and I need to display the data that matches any of those selections. 


Prefenrece Sharepoint list layout: 

User_Preference list 
User (Text Column) / Color_Preference (Choice column) ===================================================== User1 / Red, Green, Blue ----------------------------------------------------- User2 / Green, Blue ----------------------------------------------------- User3 / Blue, Red ----------------------------------------------------- User4 / Blue ----------------------------------------------------- User5 / Green -----------------------------------------------------

Data Sharepoint list layout: 

User_Data list
Color (Text)
========================= Blue ------------------------------------------- Green ------------------------------------------- Red ------------------------------------------- Blue ------------------------------------------- Green -------------------------------------------

The formula im trying to achive:

ClearCollect(IdentifiedUser, Filter(User_Preference, User = "User1" ) );
ClearCollect(FilteredData, Filter(User_Data, Color = IdentifiedUser.ColorPreference.Value ));

Where im struggling is that this part of the code:

Color = IdentifiedUser.ColorPreference.Value

How can I filter the color colum so that it returns data that matches any of of the user`s choices?



Accepted Solutions

Not applicable

adding in @Chris to assist with this SharePoint question. 



Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.


New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (3,707)