cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Owizardo
Level: Powered On

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
Power Apps Staff Chris
Power Apps Staff

Re: Compare Text to a Choice Column

2 REPLIES 2
TopShelf-MSFT
Level 10

Re: Compare Text to a Choice Column

adding in @Chris to assist with this SharePoint question. 

 

@TopShelf-MSFT

Power Apps Staff Chris
Power Apps Staff

Re: Compare Text to a Choice Column

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,381)