Power Apps

ThisRecord.Value makes an error inside a IF sentence

(0) Share

Report

Posted on by EmilioRoqueta69

565

Hi,

I have these set of data:

And for create the collection colUsers, I wrote:

ClearCollect(colUsers , AddColumns(colUniqueRequests, Country, Office365Users.UserProfileV2(ThisRecord.Value).country) , Name, Office365Users.UserProfileV2(ThisRecord.Value).displayName));

But, if I need to check is the user has another country setup in the tabla Holiday_Employees, I did:

ClearCollect(colUsers , AddColumns(colUniqueRequests, Country, If(!IsBlank(LookUp(Holiday_Employees, Email=ThisRecord.Value).Country.Name), LookUp(Holiday_Employees, Email=ThisRecord.Value).Country.Name, Office365Users.UserProfileV2(ThisRecord.Value).country) , Name, Office365Users.UserProfileV2(ThisRecord.Value).displayName));

And here, ThisRecord.value makes an error:

How can I fix it? Thanks for any help.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Try&Try 8 on at

Like
a
(1)

Report
Copy link

Link copied!

Have you tried ThisRecord.Email
or ThisRecord.Email. and See what available options you have?

Was this reply helpful? Yes No
Suggested answer

timl 37,229 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi EmilioRoqueta69

ThisRecord shouldn't be necessary here because it'll reference the Holiday_Employees table rather than the colUniqueRequests collection.

This should hopefully work better for you.

ClearCollect( colUsers, AddColumns( colUniqueRequests, Country, If( !IsBlank(LookUp(Holiday_Employees, Email = Value).Country.Name), LookUp(Holiday_Employees, Email = Value).Country.Name, Office365Users.UserProfileV2(Value).country ), Name, Office365Users.UserProfileV2(Value).displayName ) );

Was this reply helpful? Yes No