Answered

Why does this query produce a result and this doesn't?

(0) Share

Report

Posted on by Kirah

Hello Community,

I have these queries which are pretty much the same query. query1&3 produces results but query2 doesn't. I am sure I have records that meet the criteria but the second query just doesn't seem to like the user check. Please any thought on this?

Query1: If(requestTab="open", Filter('Requests','Request User'.Email=User().Email))

Query2: Filter('Requests',If(requestTab="open",'Request User'.Email=User().Email)) - This is pretty much same as above but written in different way and produced no result...

Query3: Filter('Requests',If(requestTab="open",'Request Status'.Value= "Submitted")) - Same query as above but different filter criteria, which produced the record.

Also found if I take the if condition out of query2 it does return the record. So it seems it just doesn't like the if statement used with user check... I'm so confused.

Regards

Kira

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,117 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Kira-Daw ,

The issue with

Filter( 'Requests', If( requestTab="open", 'Request User'.Email=User().Email ) )

that I see is that the condition under which you want to filter is not related to the filter itself and therefore needs to be outside it. Your first example is correct. I am surprised thsat the third on eproduced a result - I suggest you stick wiht the first syntax.

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.

Visit my blog Practical Power Apps

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @Kira-Daw

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Kirah 72 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Thank you for your advice on this. It's helped reassured me. I went with your recommended approach instead, and I'm happy with this.

Thanks again!
Kira

Was this reply helpful? Yes No