formula does not return records

[octaking]

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)

[RezaDorrani]

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(varUserEmail,User().Email);

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

see if you get value

next try just

loading Users into a collection

clearcollect(colUsers,Users)

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

[octaking]

Hi @RezaDorrani 

The test brings the data we hope look

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

the label 2 is : the variable Email

And the collection also returns of all users username

[RezaDorrani]

Hi @octaking 

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

what does this give you

[octaking]

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

[RezaDorrani]

Hi @octaking 

I have a you tube channel 🙂

Please subscribe to it

https://www.youtube.com/channel/UCvBYTqRx-n_8KzFO0MJlUVw?view_as=subscriber

Regards,

Reza Dorrani

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

[octaking]

you already have a new subscriber 😄