Filter a gallery

(0) Share

Report

Posted on by Kosenurm

802

I have a gallery connected to my Dataverse table.

I want to show in the gallery only the records Created By the current logged in user.

I have tried "ThisItem.'Created By'.'Full Name' = User().FullName" but this returns 'true', rather than the person's name. How can I get it to show the user's name here?

The other fields in the gallery are 'Desk Reference' and 'Desk Reservation Date' - again, I only want these to pull back in the gallery if they are the current user's.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

C-Papa 1,836 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi, you can filter the datasource / gallery based on the user, this will then show the values that are created by the current user. if you change the gallery data source / items to something like the below.

Filter([MYDATASOURCE], CreatedBy.FullName = User().FullName)

Was this reply helpful? Yes No
Kosenurm 802 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. One final thing, how can I also filter it so it only shows items with a Reserved For Date of today or in the future, not in the past?

Thanks,
K.

Was this reply helpful? Yes No
C-Papa 1,836 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Assuming your Reserved For Date is a Date column you should be able to do the below, change ReservedForDate for what ever your actual column names is

Filter([MYDATASOURCE], CreatedBy.FullName = User().FullName && ReservedForDate >= Today())

Was this reply helpful? Yes No