2 Sharepoint lists person column multiple values - form

(0) Share

Report

Posted on by Evina

Hello community,

I hope someone can assist me.

I have 2 Sharepoint lists

'MainList' - where data will be entered through a form
'LookUpList'

In 'LookUpList' I have a People column which allows multiple values called AccountContactEmail2 (and shows field as Email)

In a Form to enter the data to the 'MainList' - based on the AccountName (DataCardValue5) someone choses, I want the info to be populated from 'LookUpList' into another datacard.

I have tried both label & combobox:

Filter('LookUpList', Concat(DataCardValue5.SelectedItems, Value& "," in Concat('MainList', Value&","))

Concat(ThisItem.'AccountContactEmail2';DisplayName;", ")

If(!IsBlank(DataCardValue5.SelectedItems.Id), LookUpList(DataCardValue5.SelectedItems.Email).mail)

Any ideas?

Thank you,

Evina

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Evina 81 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried various syntaxes like:

If(!IsBlank(DataCardValue5.Selected.Title), Concat(Lookuplist.AccountContacts2, Email, "; "), Email

Anyone able to assist ?
Verified answer

Evina 81 on at

Like
a
(0)

Report
Copy link

Link copied!

I just did a happy dance because I figured it out, with the help of this post

Solved: Convert Sharepoint People Displayname from Table t... - Power Platform Community (microsoft.com)

My Solution was in a label:
LookUp(LookUpList, Title = DataCardValue5.Selected.Value, Concat(AccountContacts2.Email,Email," ; "))
Ramole Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Evina

Well done, if you did solved then go ahead and Accept as Solution yours so it will help others