Dependency on SharePoint lookup column

(1) Share

Report

Posted on by michelledroll1

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!

All responses (1)

Answers (0)

Ami K 15,665 Super User 2024 Season 1 on at

Like (0)

Report
Re: Dependency on SharePoint lookup column

@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:

Concat( ForAll( 'Your ComboBox'.SelectedItems As selecteditems, LookUp( 'SharePoint List B', ID = selecteditems.Id, 'Your Email Field' ) ), Value, ";" )