Unanswered

Complex If Statement with Filters

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am trying to show some data in a gallery based on the name of the user, the role of the user, and if the event date is today.

I can get these to work separately but I can't get them to work together. This one will only show me items based on the user's permissions (event lead or event coordinator) but I can't get it to filter by date.

If(varName.'Event Lead' = 'Event Lead (Event Memo Users)'.Yes, 'Event Memos',Filter('Event Memos','Event Coordinator Name' = varName.Name))

This one will filter the date to only show today's events, which I want in addition to the items above.

Filter('Event Memos', IsToday('Start Date and Time'))

Can I get some help with this?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

WarrenBelz 156,458 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,
Yes date filters with = equals are tricky - try the below
If( varName.'Event Lead' = 'Event Lead (Event Memo Users)'.Yes, 'Event Memos', Filter( 'Event Memos', 'Event Coordinator Name' = varName.Name && DateDiff( 'Start Date and Time', Today(), Days )=0 ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
Thanks for the help. I got it to work half way. It worked when the person logged in was an event coordinator because that's what the if statement said. The issue though is if an event lead logs in they still see everything.
I moved the filter in front and at the end but the ; was giving me an error that it wasn't the expected operator.

I event tried the original date filter I had and it still gave me the same error. I have no idea why it's doing that.

Filter('Event Memos',DateDiff('Start Date and Time',Today(),Days)=0);
If(
varName.'Event Lead' = 'Event Lead (Event Memo Users)'.Yes,
'Event Memos',
Filter('Event Memos',
'Event Coordinator Name' = varName.Name ))

Thoughts?

Was this reply helpful? Yes No
WarrenBelz 156,458 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,
Try this (free-typed so watch commas/brackets)
Filter( 'Event Memos', DateDiff( 'Start Date and Time', Today(), Days )=0 && If( varName.'Event Lead' <> 'Event Lead (Event Memo Users)'.Yes, 'Event Coordinator Name' = varName.Name ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 156,458 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz sorry not been able to try it yet. Projects have been shifted to what happens when we reopen. I will keep posting as I work on things.

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz I just tried it and if I login as the Event Coordinator the event shows up correctly. However if I login as the Lead it doesn't show anything.
What am I missing?

Was this reply helpful? Yes No
WarrenBelz 156,458 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
OK @Anonymous ,
Before I start looking into the logic of your data structure, try this
Filter( 'Event Memos', If( varName.'Event Lead' = 'Event Lead (Event Memo Users)'.Yes, DateDiff( 'Start Date and Time', Today(), Days )=0 && Event Coordinator Name' = varName.Name, DateDiff( 'Start Date and Time', Today(), Days )=0 ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 156,458 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No