Answered

How to exclude outside domain user when saving data in a Person column

(0) Share

Report

Posted on by hkmamun

106

Hi, In my Power App I am taking my events from Outlook Calendar and saving data in a SharePoint list. In SharePoint list with other columns also I have a Person column (Allow : multiple) named "Participants" and another Single line text column named "OtherParticipants" where I need to save "requiredAttendees" field's value of Outlook event.

Let's say the value of requiredAttendees="mamun@mydomain.com;abc@mydomain.com;xyz@otherdomain.com;zyx@otherdomain.com;"

So now I have to save the value of "@mydomain.com" users to "Participants" column and "@otherdomain.com" users to "OtherParticipants" column. I have tried few ways to save data in the "Participants" column but for outside domain users I am getting error "An Unknown error occurred" message. below is my code (though I did not try to save data in the "OtherParticipants" column yet

Participants: If(requiredAttendees<>"",
 ForAll(
 Split(
 Left(requiredAttendees,Len(requiredAttendees)-1),
 ";"
 ),If(Text(Trim(Result)) in Office365Users.SearchUserV2().value.Mail,
 { 
 DisplayName: Office365Users.UserProfileV2(Text(Trim(Result))).displayName,
 Claims: "i:0#.f|membership|" & Lower(Office365Users.UserProfileV2(Text(Trim(Result))).userPrincipalName),
 Department: "",
 Email: Office365Users.UserProfileV2(Text(Trim(Result))).userPrincipalName,
 JobTitle: "",
 Picture: ""
 })
 )
 )

In the place of 2nd If condition (If(Text(Trim(Result)) in Office365Users.SearchUserV2().value.Mail), I have tried below ways also but always getting same error

1. IsMatch(Substitute(Right(Text(Trim(Result)),Len(Text(Trim(Result))) - Find("@",Text(Trim(Result)))),";",""),UserDomain,Contains & IgnoreCase)

2. Lower(Substitute(Right(Text(Trim(Result)),Len(Text(Trim(Result))) - Find("@",Text(Trim(Result)))),";",""))=Lower(UserDomain)

3. (Find(Lower(UserDomain),Lower(Text(Trim(Result)))))>0

4. !(IsEmpty(Office365Users.UserProfileV2(Text(Trim(Result)))))

5. If(Text(Trim(Result)) in Office365Users.SearchUserV2().value.Mail

Can you please help me actually what am I missing? Also if possible add code for "OtherParticipant" column

Very urgent help needed!!!

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

KrishnaV 5,023 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @hkmamun ,

Try this:
Participants: If(requiredAttendees<>"", ForAll( Split( Left(requiredAttendees,Len(requiredAttendees)-1), ";" ),If((Text(Trim(Result)) in Office365Users.SearchUserV2().value.Mail And !IsBlank(Office365Users.UserProfileV2(Text(Trim(Result))).displayName)), { DisplayName: Office365Users.UserProfileV2(Text(Trim(Result))).displayName, Claims: "i:0#.f|membership|" & Lower(Office365Users.UserProfileV2(Text(Trim(Result))).userPrincipalName), Department: "", Email: Office365Users.UserProfileV2(Text(Trim(Result))).userPrincipalName, JobTitle: "", Picture: "" }) ) )

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @hkmamun ,

Do you submit your data to your SP List using Patch function?

Based on the formula that you mentioned, I think there is something wrong with it. I have made a test on my side, please take a try with the following workaround:

Please consider modify your formula as below:

Participants: If( requiredAttendees <> "", ForAll( Filter( // Add filter formula here to filter your domain users Split( Left(requiredAttendees, Len(requiredAttendees)-1), ";" ), Lower(Last(Split(First(Split(Office365Users.MyProfileV2().mail, ".")).Result, "@")).Result) in Lower(Result) ), { DisplayName: Office365Users.UserProfileV2(Trim(Result)).displayName, Claims: "i:0#.f|membership|" & Lower(Trim(Result)), Email: Trim(Result), Department: "", JobTitle: "", Picture: "" } ) )

The following formula in above Filter function is used to get the domain name (e.g. mydomain) from your email address:

Last(Split(First(Split(Office365Users.MyProfileV2().mail, ".")).Result, "@")).Result

Please consider take a try with above solution, check if the issue is solved.

For the "OtherParticipants" Text field inside your Patch function, please try the following formula:

OtherParticipants: If( requiredAttendees <> "", Concat( Filter( Split( Left(requiredAttendees, Len(requiredAttendees)-1), ";" ), Not(Lower(Last(Split(First(Split(Office365Users.MyProfileV2().mail, ".")).Result, "@")).Result) in Lower(Result)) ), Result & ";" ) )

Please consider take a try with above formula, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No