Power Platform Community Forum Thread Details

I'm working within a ForAll, and Attempting to UpdateIF, however in the UpdateIf Statement, I don't have Access to "ThisRecord.EmailAddress" from the ForAll. Is there a way to reference ThisRecord in the Nested UpdateIf?

ForAll(Collection1,

If(CountRows(UpdateIf('SharePointList',StartDate = StartDate1,
{Title: Office365Users.UserProfile(ThisRecord.EmailAddress).Mail})) > 0,"Exist","Doesn't Exist");

Categories:

Building Power Apps

@IceCat

Please consider changing your Formula to the following:

ForAll(Collection1 As _col,
 If(
 CountRows(
 UpdateIf('SharePointList',
 StartDate = StartDate1,
 {Title: Office365Users.UserProfile(_col.EmailAddress).Mail}
 )
 ) > 0,
 "Exist",
 "Doesn't Exist"
);

Now, that said...you have some issues with your formula in general.

1) You are counting the rows of the UpdateIf...UpdateIf returns the full table of records from the datasource. So, you will never have a your false condition ("Doesn't Exist") as you will never get 0 back.

2) Your ForAll will be returning a single column Table of Values. You will end up with a table with as many rows in your Collection1 and each value will be "Exist".

3) I assumed StartDate1 was some other variable and not in your collection.

So, I would review the above to determine what you are really trying to do.

I hope this is helpful for you.