filter gallery to show Favorites based on SP list column

(0) Share

Report

Posted on by Chwilkinson

125

Hi Everyone,

I'm working on a networking powerapp.

people can log on and create a personal profile to offer mentorship and support for others in the organization.

Each profile is a line on a SP list. One of the columns is a favorites column, users can add their favorite users to that column,

I'd then like to filter a gallery to just show their favorite users, but I'm struggling to work out how to look up the contents of the favorites cell of the current logged in user and then filter the gallery by all of the names in that cell.

List = People in organisation

Title	Person	Job Title	Location	Favourites
Single line of text (varUserFullName)	Person Group	Single line of text	Single line of text	Single line of text
John Doe	John Doe	Editor	New York	Jane Doe, Rob Smith, Alexa Kim
Jane Doe	Jane Doe	Creative Consultant	London	John Doe, Jane Doe
Rob Smith	Rob Smith	Head of Department	Paris	Robyn Smith, Alex Kim, Alexa Kim
Robyn Smith	Robyn Smith	PA	Lisbon	John Doe
Alex Kim	Alex Kim	Director	Washington	Jane Doe, Robyn Smith, Alexa Kim
Alexa Kim	Alexa Kim	CEO	Berlin	Jane Doe, Rob Smith

Any suggestions would be really appreciated

Thanks

Chris

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

gcmfaizan 1,022 on at

Like (0)

Report
Copy link

Link copied!
Hi @Chwilkinson ,

to achieve this create a collection on OnStart of the app:
ClearCollect( colUserFavorites, Filter( 'YourDataSourceName', Title = User().FullName ).Favourites );
in your gallery Item property use this formula to get records as per current user favourites:
Filter( 'YourDataSourceName', colUserFavorites.Value in FullName )

If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

Cheers!

Was this reply helpful? Yes No
Chwilkinson 125 on at

Like (0)

Report
Copy link

Link copied!

HI @gcmfaizan
Thanks for the reply, The collection was a great shout but its not liking the filter on the gallery, collection is a table and the field is looking for text, just trying to work out how to convert it.
Thanks
Chris

Was this reply helpful? Yes No