cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Burner1
Frequent Visitor

Saving Multi Select values from SharePoint to a collection

Hi,

 

With the app I'm currently building a user can enter values in a PowerApp screen. With a button at the bottom of the screen the item will be saved to a collection to have it patched later on. One of the values is a multi select field from SharePoint. I want to save the values from that multi select to a collection, so I can submit the item later on to SharePoint with the patch function:

(ForAll([Source collection]; Patch([SharePoint list]; Defaults([SharePoint list]); { DATA }))

I'm trying to save the multi select with the following code:

Collect(RecurringEvent; {
    TitleColl: TitleNewValueHE.Text;              
    MultiSelect: MultiSelectValueHE.SelectedItems;
    });;

But it returns that it is incompatible with the collection. Probably because it is actually a table...? 

 

How can you get the values from a multi select to a collection?

 

Hopefully anyone can help me Smiley Happy

 

1 ACCEPTED SOLUTION

Accepted Solutions
Burner1
Frequent Visitor

Thought I would not come to a solution after hours of searching for a solution... After this post i tried the following and it works!

Collect(RecurringEvent; {
    TitleColl: TitleNewValueHE.Text;              
    MultiSelectColl: { MultiSelect: MultiSelectValueHE.SelectedItems };
    });;

It creates a record with the table inside. After this it's easy to patch it with:

MultiSelectColl.MultiSelect.

View solution in original post

1 REPLY 1
Burner1
Frequent Visitor

Thought I would not come to a solution after hours of searching for a solution... After this post i tried the following and it works!

Collect(RecurringEvent; {
    TitleColl: TitleNewValueHE.Text;              
    MultiSelectColl: { MultiSelect: MultiSelectValueHE.SelectedItems };
    });;

It creates a record with the table inside. After this it's easy to patch it with:

MultiSelectColl.MultiSelect.

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,704)