Code for Filtering Gallery By User does not show error but it doesn't show records either.

(0) Share

Report

Posted on by ShondaT

228

Why is this code not rendering any results when there are records that I have created.

Filter( 'NEST Intake System', 'Created By'.Email=varUser)

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

Sort by

BCBuizer 22,654 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @ShondaT ,

The condition in your filter is case sensitive. Can you make sure the casing matches between the value of varUser and what's in your data source?

If this is the issue, you can use the Lower() function to change all capitals to lower cases which will help overcome this limitation.

Was this reply helpful? Yes No
ShondaT 228 on at

Like (0)

Report
Copy link

Link copied!

@BC

Below is the result of that. Did I apply it incorrectly?

Was this reply helpful? Yes No
BCBuizer 22,654 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @ShondaT ,

It seems there's a closing bracket missing.

Also, has anything changed? Before you were comparing 'Created By'.Email with VarUser and in this screenshot it's 'Creator Email' and User().Email .

Was this reply helpful? Yes No
ShondaT 228 on at

Like (0)

Report
Copy link

Link copied!

@BCBuizer

My bad on that...I did added it and there's the delegation issue but it's still not rendering any results. I've tried both ways and they continue to render no results. I'm just throwing everything at it that I can think of.

Here's what happens without the change:

Was this reply helpful? Yes No
ShondaT 228 on at

Like (0)

Report
Copy link

Link copied!

@BCBuizer I've revised my response to your response.

Was this reply helpful? Yes No
mmollet 3,187 on at

Like (0)

Report
Copy link

Link copied!

Try:
Filter('NEST Intake System', 'Created By'.Email=User().Email)

Make sure to not have a ';' after this statement as for some reason when I tested this it threw an error. Very weird that it does so imo. Also Created By and User().Email shouldn't need the to lower function as they are both set by the system and in both cases are grabbed from the same variable from the user. The only way I can see this being an issue is if you recently changed the email from the admin center or something and now they arent the same.

Also check your text inputs in your gallery and see what the error is on each of those. The gallery isnt throwing an error but the controls inside of it are. Makes me think seeing that might be of some help in getting this solved.

Another thing you can do is to highlight just the 'Created By' and see what that variable is holding then highlight the User().Email and see that they match. If so then you can be sure that this string comparison isn't the issue.

Was this reply helpful? Yes No
ShondaT 228 on at

Like (0)

Report
Copy link

Link copied!

Thanks @mmollet. I tried your code: Filter('NEST Intake System','Created By'.Email=User().Email)

and it's still rendering no results. When I inspect user() it shows me and my email address. Nothing comes up when I select Created By.

When I add the Created By field to my form and remove the filter so all records show, my name appears in the field.

I am really at a loss and I have to get this done today. 😞

Was this reply helpful? Yes No
mmollet 3,187 on at

Like (0)

Report
Copy link

Link copied!

We will figure it out for sure!

First I want to confirm that I understand what you are needing.
You have a gallery that is linked to a SP list?
You want to only show items in that gallery that the current user created?

Also I believe that CreateBy returns the FullName not the Email now that I am looking at it so first you should try:
Filter('NEST Intake System','Created By'=User().FullName)
Im hoping that just fixes it. Sorry for bad info yesterday!

Was this reply helpful? Yes No
ShondaT 228 on at

Like (0)

Report
Copy link

Link copied!

@mmollet You are correct! That's exactly what I'm trying to do.

It doesn't seem to like the "=". I get the red squiggly.

I tried doing 'Created by'.FullName=User().Fullname) just for kicks. "Fullname for Created By doesn't even appear as an option like "email" does.

When the code appears to be error free, it just comes back with "We didn't find any data."

I've also tried the code on my "Requestor" column which autopopulates with the current user's name as a result of the following code added to the DefaultSelectedItems of the DataCardValue:

If(NCAForm_1.Mode = FormMode.New, {'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims:Concatenate("i:0#.f|membership|",User().Email), DisplayName:User().FullName, Email:User().Email}, ThisItem.Requestor)

Maybe something in that code can help identify a possible solution?

By the way thank you so much for your time and really wanting to help me figure this out. 🙂

Was this reply helpful? Yes No
mmollet 3,187 on at

Like (0)

Report
Copy link

Link copied!

Have you tried just make a new screen and dropping in a gallery. Just delete everything out of it and add a textbox or 2 with the important data so you know what it is showing is correct such as wherever you are storing the user name. Then set the items property to the code I sent previously and see if it works on a more simple gallery. If it does then you can be sure that it isnt that code. I have a gallery here that is working with the filter I provided but the set up and other parts are obviously not the same as what you have. When I get stuck like this I generally try to start from the most basic element and then add functionality until I figure out what the issue is.

To check what is stored in 'Created By' you could always go into the list settings for that list and then show that column and see what value it has. When I did this it just had Full Name of the user stored in it.

Also NP! I am going to do my best to get this resolved today just hang in there 🙂

Was this reply helpful? Yes No