Power Platform Community Forum Thread Details

Hi,

I have these set of data:

And for example, this formula to create colUsers collection works:

ClearCollect(colUsers , AddColumns(colUniqueRequests, Country, Office365Users.UserProfileV2(ThisRecord.Value).country , Name, 
Office365Users.UserProfileV2(ThisRecord.Value).displayName));
 
But, If instead of looking the country with Office365Users.UserProfileV2(ThisRecord.Value).country
I need first to check if there is a record for this email in the Holiday_Employees table, so I write:
 
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, the ThisRecord.Value makes an error inside the IF sentence.
 
 
I do not know how to fix that.
Thanks for any help!