Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

formula does not return records

Hello, I have the following formula that does not give any error but does not bring me the records that I must return

I'm sure that's how the owner gets it and I know it because it works in another gallery

and the filter Approval.Status = 'Status (Approvals)'. Activate The status is fine because in the same way it is already in a gallery and works correctly

but when I want to do this in a single formula, it doesn't return the records:


SortByColumns( Filter( AddColumns('Approval Requests', "Owner_Email", AsType(Owner, Usuarios).'Correo electrónico principal'), Approval.Status = 'Status (Approvals)'.Active, Owner_Email = User().Email), "createdon", Descending)


download (9).png


Hi @octaking 


First try and get data in varUserObj


for that break formula up into different parts and test


Add a button - onselect for button 


Set(varuserObj,LookUp(Users,('User Name')=(varUserEmail)));


see if you get value


next try just

loading Users into a collection


then for a label text try

First(colUsers).'User Name' 

check value


Also in a label try varUserEmail and check its value


There must be something very easy that is missed




Hi @RezaDorrani 

The test brings the data we hope look


the label 1 is : First(colUser).'UserName'

the label 2 is : the variable Email


download (15).png


And the collection also returns of all users username

Hi @octaking 


CountRows(Filter(Users,('User Name')=(varUserEmail)))


what does this give you

CountRows (Filter (Users, ('User Name') = (varUserEmail)))

has returned me 1


and check the gallery where I want to show the data and this time if the result has returned the records I expected 🙂

I think about who activated this is:

ClearCollect (user, users)


thank you very much Reza without a doubt in the community you are the best 🙂

you should open a youtube channel for powerapps


Hi @octaking 


I have a you tube channel 🙂

Please subscribe to it



Reza Dorrani


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly



you already have a new subscriber 😄

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (17,617)