Feed combobox from text column (SPO LIST) with multiple values

(0) Share

Report

Posted on by Sifu

834

Hi guys,

i have a combobox that has a source another sharepoint list
ITEMS:

'Customer Visit - Access list'.Title

so far all good, once i save the choices to the list with a patch:

Patch('Customer Visit - Registration', LookUp('Customer Visit - Registration', Title = visitID_1.Text),
{ SharedWith: Concat(sharedwith.SelectedItems.Title, Title & ",") } )

i want to make it again visible for the user who opens this "case" again... but this wont work...
DefaultSelectedItems

ForAll(
 Split(LookUp('Customer Visit - Registration', Title = visitID_1.Text).SharedWith, ","),
 {
 Value: Result
 }
)

any idea how to build the default selected items?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Sifu

Consider changing your formula to the following:

ForAll( Split(LookUp('Customer Visit - Registration', Title = visitID_1.Text).SharedWith, ","), { Title: Result } )

Your formula for the Items does a narrowing filter to return only the Title column. Therefore your DefaultSelectedItems must match. In your original formula "Value:" does not match "Title:"

I hope this is helpful for you.

Was this reply helpful? Yes No
Sifu 834 on at

Like
a
(0)

Report
Copy link

Link copied!

hi, thanks for feedback but did not help 😞
does the default property requires something else? ....currently empty... or some thing else?

Was this reply helpful? Yes No
Sifu 834 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes just an idea, could it be different...currently not working because its in a gallery?

Was this reply helpful? Yes No
Verified answer

Sifu 834 on at

Like
a
(0)

Report
Copy link

Link copied!
@RandyHayes I figured it out... the problem was in the patch... it puts a comma even after the last one which is something the combo does not like...
Patch('Customer Visit - Registration', LookUp('Customer Visit - Registration', Title = visitID_1.Text), { SharedWith: Concat(sharedwith.SelectedItems.Title, Title & ",") } )

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Sifu

Ah yes, you need to filter those out...

ForAll( Filter( Split(LookUp('Customer Visit - Registration', Title = visitID_1.Text).SharedWith, ","), !IsBlank(Result) ) { Title: Result } )

Was this reply helpful? Yes No
Sifu 834 on at

Like
a
(0)

Report
Copy link

Link copied!

no, i chcanged the patch so I dont write the last column with (left (len - 1).... works great

Was this reply helpful? Yes No