Splitting Microsoft Membership Code

(0) Share

Report

Posted on by DanMuriel

Hello group,

I wanted to for your support in being able to split/separate the following data from a multiselect person field.

I was able to pull the membership information for the multi selection, but now I need only a specific section of the ID for example:

This is the information that I am capturing but I need to be able to pull only DoeJoh, DoeJan, SmithJ from the following data:

are there any recommendations? I am only able to do it for the first one but if there are multiple users selected anything after the first semicolon is ignored.

Hope someone can help

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 154,534 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @DanMuriel ,
Try
Substitute( Substitute( YourControlName.Text, "i:0#.f|membership|", "" ), "@company.com;" ", " )
and if you want to get rid of the last comma and space, try this
With( { eName: Substitute( Substitute( YourControlName.Text, "i:0#.f|membership|", "" ), "@company.com;" ", " }, Left(eName,Len(eName)-2) )

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.

Was this reply helpful? Yes No
WarrenBelz 154,534 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @DanMuriel ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Was this reply helpful? Yes No