Answered

How can I get mutiple values from a sharepoint list and display them in one Combibox

(0) Share

Report

Posted on by TP1

My problem is, I have a submit form (it is not actually a from, mutiple fields that are pushed via patch function). I also have an edit mode and I want to get values from the sharepoint list to display them in the edit form. Works fine for every field, but i have a Stakeholder Field and there I need to get a typ match with the values from the office365 users and that is not working if there can be multiple users.

This is the default selected item for another value, but that are predefined values:

Filter(
["EU"; "NAR"; "RDW"; "CHN"; "Unknown"];
Value in Split(LookUp(Fehlerstatus; Titel = Gallery2.Selected.Title).AffectedMarkets; ",").Value
)

I want to have something like that for mutiple values, but something like this doesn't work:

ForAll(
Split(LookUp(UserList, Titel = Gallery2.Selected.Title).UserField, ","),
LookUp(Office365Users.SearchUser(), DisplayName = Trim(Result) || Mail = Trim(Result))
)

Do you have any idea?

LookUp('Office365-Benutzer'.SearchUser(); DisplayName = LookUp(Fehlerstatus; Titel = Gallery2.Selected.Title).RequirementOwner)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-jefferni on at

Like (0)

Report

Hi @TP1 ,

Could you please share more details about your scenario? What's the type of the column you want to populate? What's the Items property of this Combo box?

Best regards,

Was this reply helpful? Yes No
TP1 4 on at

Like (0)

Report

Hi, the data type of the sharepoint list is single line text. On create i push the selected values from the combobox seperated with semicolon to the sharepoint list ( Stakeholder: Concat(Stakeholder.SelectedItems; DisplayName & "; ")). The items property of the stakeholder combobox is this: 'Office365-Benutzer'.SearchUser({searchTerm:Self.SearchText; top:999})

Was this reply helpful? Yes No
TP1 4 on at

Like (0)

Report

The problem is now the edit mode. It is another window, i want to prefill the field of the stakeholder field from the sharepoint list. So i need to seperate the multiple users from the sharepoint list and match them with the values from the office365 users.

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report
Hi @TP1 ,

Try below formula in DefaultSelectedItems:

UnGroup( ForAll( Split(Parent.Default; ";"); 'Office365-Benutzer'.SearchUser({searchTerm: ThisRecord.Value; top:1}) ); "Value" )

Best regards,

Was this reply helpful? Yes No