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

Re: Saving Multi Select values from SharePoint to a collection

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

Re: Saving Multi Select values from SharePoint to a collection

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
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (5,073)