cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
PowerApps Staff Chris
PowerApps Staff

Re: Compare Text to a Choice Column

2 REPLIES 2
Administrator
Administrator

Re: Compare Text to a Choice Column

adding in @Chris to assist with this SharePoint question. 

 

@TopShelf-MSFT

PowerApps Staff Chris
PowerApps Staff

Re: Compare Text to a Choice Column

Helpful resources

Announcements
thirdimage

Power Automate 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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 407 members 5,065 guests
Please welcome our newest community members: