ForAll loop error

(0) Share

Report

Posted on by usaman45

314

List code below is not able to run, any idea how to fix it? Thanks!

ClearCollect( colInfoEmailList, { Name: "", Mail: "", UPN: "", Type: "" } );

// Loop through the EmailArray and check each email address
ForAll(
Split("UserA@gmail.com;UserB@gmail.com", ";"),
// Get the user profile information using the Office365Users connector
Set(UserProfile, Office365Users.UserProfileV2(Result));
// Check if the user profile is blank or not
If(
// If not blank, add the user profile information and the type column to the Collection
!IsBlank(colInfoEmailList),
Collect(
colInfoEmailList,
{
DisplayName: UserProfile.displayName,
Mail: UserProfile.mail,
UserPrincipalName: UserProfile.userPrincipalName,
Type: "User"
}
)
)
);

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

WarrenBelz 152,867 Most Valuable Professional on at

Like (0)

Report
Hi @usaman45 ,

WHat exactly are you trying to do here ?

ForAll( Split( "UserA@gmail.com;UserB@gmail.com", ";" ), Set( UserProfile, Office365Users.UserProfileV2(Result) );

you cannot set a Variable inside ForAll() - also the output of Split is Value, not Result (it was changed some time ago).

If you want the first non-blank profile, you could do this

Set( UserProfile, Coalesce( Office365Users.UserProfileV2(UserA@gmail.com), Office365Users.UserProfileV2(UserB@gmail.com) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
usaman45 314 on at

Like (0)

Report

My goal is to loop through a string that has multiple email addresses and check if they are active or not. If an email address is active, I want to add it to a UserCollection with the following attributes: DisplayName: UserProfile.displayName, Mail: UserProfile.mail, UserPrincipalName: UserProfile.userPrincipalName, Type: “User”
Is there a better way to do this?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 152,867 Most Valuable Professional on at

Like (0)

Report
Hi @usaman45 ,

Something like this should do it

ForAll( Split( "UserA@gmail.com;UserB@gmail.com", ";" ), With( {_Profile: Office365Users.UserProfileV2(Value)}, If( !IsBlank(_Profile.mail), Collect( colInfoEmailList, { DisplayName: _Profile.displayName, Mail: _Profile.mail, UserPrincipalName: _Profile.userPrincipalName, Type: "User" } ) ) ) );

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No