Filter by multiple criteria after Selecting a user from a previous gallery

(0) Share

Report

Posted on by gazzo1967

1,151

Hi

i want to filter calendar entries based on the name selected equal to calendar 'created by'

I have a gallery showing a list of specific names from a Sharepoint List.
The user selects a preferred person which then goes to a calendar view.
OnSelect Navigate('BA SBA Calender',ScreenTransition.None, {selectedID: Gallery1.Selected.person_name})

this then navigates to the next screen which has the calendar on it.
I then use this on my 'CalendarEventsGallery2'

Filter('BA SBA Booking', Text('Start Time', DateTimeFormat.ShortDate) = Text(_dateSelected, DateTimeFormat.ShortDate) && Gallery1.Selected.person_name in 'Created By')
or if i use

Filter('BA SBA Booking', Text('Start Time', DateTimeFormat.ShortDate) = Text(_dateSelected, DateTimeFormat.ShortDate) && Gallery1.Selected.person_name in 'Created By')

But i get an error 'Cannot use record values in this context'

Gallery1 is the on the previous screen
Ideally i would like to do this by collection but don't really understand how to do that 😞
Thanks Gary

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

gazzo1967 1,151 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi All
Just so it might help others.

I found that the issue was that i was missing DisplayName in my filter options
My previous filter was:
Filter('BA SBA Booking', Text('Start Time', DateTimeFormat.ShortDate) = Text(_dateSelected, DateTimeFormat.ShortDate) && Gallery1.Selected.person_name in 'Created By')

But when i added DisplayName to the second criteria values it works 🙂

Filter('BA SBA Booking', Text('Start Time', DateTimeFormat.ShortDate) = Text(_dateSelected, DateTimeFormat.ShortDate ) && 'Created By'.DisplayName in Gallery1.Selected.person_name.DisplayName)

Hopefully that will help someone later 🙂
Gary

Was this reply helpful? Yes No
alrezac Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

Looks like you were able to solve your issue here on your own. I wanted to just add in here a link to some documentation on look ups in Canvas Apps. Take a look if you would like to learn more.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/working-with-references

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No