Answered

combine Multi select dropdown SharePoint field that reads data from child list

(2) Share

Report

Posted on by erkindunyaWork

Hi,
I have Parent and Child SharePoint lists to for a requirement to send email. When single Impacted Platform selected I managed to lookup child list and bring the emails on main PowerApps but if end user selects two or more Impacted Platform I could not managed to lookup child list and join these email address as single selected how can I do it.
The working formula for single Impacted Platform selection is below

Concat(LookUp('Impacted Platforms', Title= Dropdown1.Selected.Title).'Notification Recipient',Email, ";")

The result is like below

Erk.king@gmail.com;Sanam.Mister@gmail.com

I tried this formula it did not work

Concat( ForAll(Dropdown1.SelectedItems,LookUp('Impacted Platforms', Title = ThisRecord.Title).'Notification Recipient'.Email),";")

Thanks in advance

The Parent list
Title: Single line of text
Impacted Platform: Choice (Checkboxes (allow multiple selections)
Impacted Platform: look up (as a look up from other child list)
emails: Multiple lines of text

Child list as small Database
Title renamed to Impacted Platform: Single line of text
Notification Recipient : Person or Group, show work email and Allow multiple selections

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Power Platform 1919 1,890 on at

Like (1)

Report
Hi @erkindunyaWork,
Concat( Dropdown1.SelectedItems As dd, LookUp( 'Impacted Platforms', Title = dd.Title ).'Notification Recipient'.Email, ";" )

can you please try this once?
and if possible, can you please the screenshot of what you are seeing in the Dropdown1.SelectedItems ?

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi @erkindunyaWork,

This one requires a bit more dissection as you are going to be returning nested Tables. Assuming the following: -

Dropdown1 contains a selection from the Title field of 'Impacted Platforms'

'Impacted Platforms' also has a multi-value Person field called 'Notification Recipient'

You want to select multiple Title values with Dropdown1

Result is a delimited Text string (;) with all email addresses from all matching records in 'Notification Recipient'

Concat( Ungroup( Ungroup( ForAll( Dropdown1.SelectedItems As _dd1, Filter( 'Impacted Platforms', Title = _dd1.Title ) ), Value ), 'Notification Recipient' ), Email, ";" )

Please click Does this answer your question 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 a Like.
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
erkindunyaWork 30 on at

Like (0)

Report

Thanks for your time and help. @Power Apps 1919

The current set up

When I try I get below error.

The function 'Concat' has some invalid arguments.

Also as an user and group field with multi value the .email is not in dropdown properties

'Notification Recipient'.Email does not work only works

in this format

LookUp(

'Impacted Platforms',

Title = Dropdown1.Selected.Title

).'Notification Recipient',

Email,

";"

)

Thanks for your time and help. @WarrenBelz

When I try I get below error.

The function 'Concat' has some invalid arguments.

The function 'Ungroup' has some invalid arguments.

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Hi @erkindunyaWork,

Are my assumptions 1-4 all correct ? If so, I have tested the code on a model with that exact structure and it returned the expected results.

Was this reply helpful? Yes No
Suggested answer

Power Platform 1919 1,890 on at

Like (0)

Report

Hi @erkindunyaWor, if possible can you share your table structure or screenshot so we can understand how to proceed and give better answer

Was this reply helpful? Yes No
erkindunyaWork 30 on at

Like (0)

Report

@Power Apps 1919

thanks this is what I set up, thanks for looking.

Was this reply helpful? Yes No
erkindunyaWork 30 on at

Like (0)

Report

@WarrenBelz thanks for looking, I tried all possible way it failed to run correctly. this is my set up 2nd image and the result on image one build on parent list impacted.

Was this reply helpful? Yes No
Power Platform 1919 1,890 on at

Like (0)

Report
Hi,
Can you try this formula once.
With( { AllRecipients: // Step 1: build one big table of all people as lookup records ForAll( Dropdown1.SelectedItems, LookUp( 'Impacted Platforms', Title = ThisRecord.Title ).'Notification Recipient' ) }, // Step 2: pull just the Email values out and join them Concat( ShowColumns(AllRecipients, "Email"), Email, ";" ) )

Note:this is freely typed code. errors might exist

Was this reply helpful? Yes No
erkindunyaWork 30 on at

Like (0)

Report

@Power Apps 1919 when I run the code it gives me these 6 errors:

Was this reply helpful? Yes No
Power Platform 1919 1,890 on at

Like (1)

Report

Hi @erkindunyaWork, My bad, I gave you wrong code, I am testing with sample lists and will provide the answer soon.

Was this reply helpful? Yes No