cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Extract Daracard Value from Multiselection of People and Split Results

Hi Team,

 

I wanted to ask for your support with the following issue, I was able to extract the information needed using 

 

Concat(DataCardValue52.SelectedItems,Claims, ";")

 

However, using claims returned additional text which is.

 

i:0#.f|membership|jdoe@email.com

 

To extract the information that i needed "JoeDoe" I used the following formula (This only works by itself): 

 

Last(FirstN(Split((Left(Mid(DataCardValue365.Selecteditems.Claims,19,40),8)),"@"),1)).Result

 

I need your help in trying to aplpy the Last formula within the Concat to only return the Users email ID without the @email.com. Being the result: 

 

Jdoe; Jdoe1; User2; Admin1; Admin2.

 

 

I hope that someone can help with this issue,

 

Thanks, 


Daniel 

3 REPLIES 3
Highlighted
Super User
Super User

Re: Extract Daracard Value from Multiselection of People and Split Results

Typically for the Claims portion I use:

 

Claims: "i:0#.f|membership|" & Lower(Combobox.Selected.Email)

 

I didn't test that with your scenario but hope it helps.

Highlighted
Frequent Visitor

Re: Extract Daracard Value from Multiselection of People and Split Results

Hi @rebeccas 

 

I did use that feature but the problem is that I am using a dropdown menu that is pulling all the names from OutLook, I need to be able to separate only a portion of the Claims fromt the multiple selection. 

 

Do you have any idea how I can do that?

 

 

-Daniel 

Highlighted
Super User
Super User

Re: Extract Daracard Value from Multiselection of People and Split Results

Not right off but I will do a little testing and see if I can come up with anything.

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (7,277)