Unanswered

Concat ForAll Multiple Multi-Select People Picker Fields, Getting DisplayName, Email, Department, and JobTitle

(0) Share

Report

Posted on by cjwilson80

Hello!

I have quite the challenge here... I have a PowerApp with several people-picker fields that I need to concatenate into a string that includes selected users' DisplayName, Email, Department, and JobTitle. I'm running a PowerAutomate flow through the app that needs JSON formatted data. The data needs to be formatted as follows:

"Insiders": [

 {

 "Department": "SYS RF Central Detection Services Abuse",

 "Email": **********@***,

 "Name": **********,

 "Role": "Deal Captain"

 },

 {

 "Department": "SYS RF Central Detection Services Abuse",

 "Email": *********@***,

 "Name": ******,

 "Role": "Deal Captain"

 }

 ],

I need this for each person selected in each field. There are 5 fields total, 3 of which allow for multiple selections. So, for each field, I need each person's info, formatted as shown above.

Right now, I have this, and it only pulls in the first field, not the remaining 4.

 Concat(
 dcNonMADealTeamMembers.SelectedItems,
 Concatenate(
 Text(DisplayName),
 "; ",
 Text(Email),
 "; ",
 Text(JobTitle),
 "; ",
 Text(Department)
 ) & Concat(
 dcMADealTeamMembers.SelectedItems,
 Concatenate(
 Text(DisplayName),
 "; ",
 Text(Email),
 "; ",
 Text(JobTitle),
 "; ",
 Text(Department)
 ) & Concat(
 dcDealCaptain.SelectedItems,
 Concatenate(
 Text(DisplayName),
 "; ",
 Text(Email),
 "; ",
 Text(JobTitle),
 "; ",
 Text(Department)
 ) & Concat(
 dcOriginatingBankers.SelectedItems,
 Concatenate(
 Text(DisplayName),
 "; ",
 Text(Email),
 "; ",
 Text(JobTitle),
 "; ",
 Text(Department)
 ) & dcLeadCoverageBanker.Selected.DisplayName & "; " & dcLeadCoverageBanker.Selected.Email & "; " & dcLeadCoverageBanker.Selected.JobTitle & "; " & dcLeadCoverageBanker.Selected.Department
 )
 )
 )
 )

Any help would be greatly appreciated, thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Meekou on at

Like
a
(0)

Report
Copy link

Link copied!
For your requirement, you could try something below which get specific column, and rename the columns based on your output, and then serialize the output to json format.
ClearCollect( UserDetails, dcMADealTeamMembers.SelectedItems, dcNonMADealTeamMembers.SelectedItems ); ClearCollect( UserDetailsSmall, RenameColumns( ShowColumns( UserDetails, Department, Mail, DisplayName, JobTitle ), Mail, Email, DisplayName, Name, JobTitle, Role ) ); Set( Result, JSON({Insiders: UserDetailsSmall}) );
Best Regards,
Meekou
YouTube
PowerApps
PowerAutomate

Was this reply helpful? Yes No
cjwilson80 95 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Meekou

Thanks for the help! I tried the code you suggested, but in the Power Automate Flow, where I need the user data, it just shows "true". The details are missing... What should I do?

Here is my code in the PowerApp:
ClearCollect( colInsiders, dcMADealTeamMembers.SelectedItems, dcNonMADealTeamMembers.SelectedItems, dcOriginatingBankers.SelectedItems, dcDealCaptain.Selected.Email, dcLeadCoverageBanker.Selected.Email ); ClearCollect( colInsidersDetails, RenameColumns( ShowColumns( colInsiders, Department, Email, DisplayName, JobTitle ), Department, Mail, DisplayName, Title ) ); Set( Result, JSON({Insiders: colInsidersDetails}) ),

Here is the output in the Compose action in Power Automate:

Was this reply helpful? Yes No
Meekou on at

Like
a
(0)

Report
Copy link

Link copied!

How did you call flow from powerapps?
Best Regards,
Meekou
YouTube
PowerApps
PowerAutomate

Was this reply helpful? Yes No
cjwilson80 95 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Meekou ,

I have a buttron in my PowerApp that has the following code OnSelect: I have a PowerAutomate flow called "MA_API_Connection" and the button, when clicked, does the RUN() function See below:
MA_API_Connection.Run( dcProposedBy.Selected.Email, dcProposedBy.Selected.Department, dcProjectCodeName.Text, "N/A", dcClientName.Text, dcPossibleConflicts.Text, dcTransactionDescription.Text, DateValue(dcDateValue.SelectedDate), dcDealType.Selected.Value & ", " & dcClientName.Text, dcNameCompanies.Text, "Mergers & Acquisition", ClearCollect( colInsiders, dcMADealTeamMembers.SelectedItems, dcNonMADealTeamMembers.SelectedItems, dcOriginatingBankers.SelectedItems, dcDealCaptain.Selected.Email, dcLeadCoverageBanker.Selected.Email ); ClearCollect( colInsidersDetails, RenameColumns( ShowColumns( colInsiders, Department, Email, DisplayName, JobTitle ), Department, Mail, DisplayName, Title ) ); Set( Result, JSON([{Insiders: colInsidersDetails}]) ), "NL Global", varFormID, If( dcExclucivityWider.Selected.Value = "Yes", true, false ), If( dcStandStill.Selected.Value = "Yes", true, false ) );

The flow runs successfully, but the "Insiders" value is just "true", it does not contain any of the user information required. See below:

Was this reply helpful? Yes No