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)

Try&Try 8 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Suggested answer

timl 36,393 Super User 2025 Season 2 on at

Like (0)

Report
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