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?
