cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Owizardo
Helper III
Helper III

Compare Text to a Choice Column

Hello,

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?

 

1 ACCEPTED SOLUTION

Accepted Solutions

2 REPLIES 2
Anonymous
Not applicable

adding in @Chris to assist with this SharePoint question. 

 

@Anonymous

Helpful resources

Announcements
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.

PA.JPG

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)