21
Dear Community Members,
I have a Lookup column in SharePoint list A that I am using in a combobox in PowerApps to display a list of crew names from SharePoint list B.
When user selects multiple crew names, I want the app to find their email addresses from list B and save them with my record. This would be hidden from user.
How do I get the email addresses into PowerApps form and what type of column would I save the data to in SharePoint?
Thank you!
@michelledroll1 - create a Single Line Text column in your SharePoint List and add that field as a DataCard into your EditForm control. On the Update property of this DataCard, use:
Share
Report
All responses (
Answers (
Concat(
ForAll(
'Your ComboBox'.SelectedItems As selecteditems,
LookUp(
'SharePoint List B',
ID = selecteditems.Id,
'Your Email Field'
)
),
Value,
";"
)
