ThisRecord.Value makes an error inside a IF sentence

(0) Share

Report

Posted on by EmilioRoqueta69

495

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:

Using Apps Using Formulas

All responses (2)

Answers (0)

Suggested answer

timl 34,933 Super User 2025 Season 1 on at

Like (0)

Report
ThisRecord.Value makes an error inside a IF sentence

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 ) );
Try&Try 8 on at

Like (1)

Report

ThisRecord.Value makes an error inside a IF sentence

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