Default selected items Concat as Text with comma separated

(1) Share

Report

Posted on by niklasjegg

533

Hello, i have a problem that i am struggling with.

I have a Combobox in my App:

Items:

Filter(Office365Users.SearchUser({searchTerm:ProjectCoreTeam_input.SearchText}),AccountEnabled=true,Not(IsBlank(Mail)),Not(IsBlank(Department)),Not(IsBlank(JobTitle)))

DefaultselectedItems

If(
 varItem.ReqTyp = "Request",varItem.Members,
 ForAll(Filter(Split(varItem.ProjectCoreTeam,";"),!IsBlank(Result)),
 First(Office365Users.SearchUserV2({searchTerm:Result,top:1}).value)
 )
)

this works fine!

However i am now trying to Patch it to my SPO List.

The Multi person field is being patched like this and works fine:

ForAll(ProjectCoreTeam_input.SelectedItems,
 Collect(Peoples,
 {
 '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 Claims: "i:0#.f|membership|" & Lower(First(Office365Users.SearchUser({searchTerm:ThisRecord.DisplayName}).Mail).Mail),
 Department: "",
 DisplayName: ThisRecord.DisplayName,
 Email: ThisRecord.Mail,
 JobTitle: "",
 Picture: ""
 }
 )
);

i am now trying to also patch a single line of text field with the info of the Member Emails. but just the emails comma separated.

Concat(ProjectCoreTeam_input.SelectedItems.Mail,Concatenate(Text(Mail),";"))

This works if i select all items fresh without any default item selected. Not with default items already in the combobox.

How can i achieve this?

BR Niklas

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

niklasjegg 533 on at

Like (0)

Report
Copy link

Link copied!
i have tried this with a text label now and i am getting email addresses separated by comma
Concat(Filter(Peoples,!IsBlank(Mail)),Lower(First(Office365Users.SearchUser({searchTerm:ThisRecord.DisplayName}).Mail).Mail) & ";")
why is this always such a rocked science thing. recently the way to collect a person was also changed....

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Concat(Peoples, Email & ";"))

You could use something like this as you already have a collection to iterate over?

Was this reply helpful? Yes No
niklasjegg 533 on at

Like (1)

Report
Copy link

Link copied!
Hi @iAm_ManCat i wish i could.
have tried it tho. Either i am getting x amount of ";" in the label depends on the number of Items. or if i use

Concat(Peoples,Mail &";")

i am getting "builtinicon:Mail".
with

Concat(Peoples,Email & ";")

i am getting ";;;;;;;;" in the text box

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Ok, so first of all Mail (with capital m) is a protected word in the Studio - you can't just use that directly as its the mail icon, so thats why it puts in builtinicon:Mail - this is part of the reason why they created a second version of the SearchUser function, SearchUserV2

I see you are using the older SearchUser and not SearchUserV2, which uses the lowercase mail that doesn't conflict with the Mail icon protected word - have you tried using the V2 function?

Was this reply helpful? Yes No