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

Creating a collection from a Sharepoint List Item's MultiValue Column

Hello,

 

I am trying to create/update a collection with the values from a SharePoint List item's multi value column, do you think you can help?

 

For example, my sharepoint list "Materials" has 3 columns

Name || Type                         || Date

 

Car     || Metal, Glass             || 10/31

House|| Wood, Metal, Glass  || 10/22

Bat     || Wood                       || 9/20

 

How would I create a collection from only the "Type" column specific to the House item so my new collection would be

newCollection = Wood, Metal, Glass

 

I attempted something like 

ClearCollect(
      newCollection,
      ShowColumns(
                'Materials', "House.Type"
)

 

But no luck. Any help would be appreciated thank you

1 ACCEPTED SOLUTION

Accepted Solutions
v-liwei-msft
Community Support
Community Support

Hi @nhung7 

 

I have made a test for your reference:

1.

vliweimsft_0-1667542276110.jpeg

2.

vliweimsft_1-1667542284928.png

3.

vliweimsft_2-1667542293064.png

 

Best Regards,

Levi

 

 

 

View solution in original post

6 REPLIES 6
DiegoEscobar2
Helper II
Helper II

Hi @nhung7. You can try with a Button in the Gallery Item with this:

Collect(newCollection,ThisItem.Type))

Does it work for you?

v-liwei-msft
Community Support
Community Support

Hi @nhung7 

 

I have made a test for your reference:

1.

vliweimsft_0-1667542276110.jpeg

2.

vliweimsft_1-1667542284928.png

3.

vliweimsft_2-1667542293064.png

 

Best Regards,

Levi

 

 

 

DiegoEscobar2
Helper II
Helper II

Hi @v-liwei-msft I have tried with 

"Collect(newCollection,ThisItem.Type))"

in OnSelect button, with same results and a more direct syntax. Do you like it?

Best regards.

Diego.

v-liwei-msft
Community Support
Community Support

Hi @DiegoEscobar2 

 

I totally agree with you, your formula is also a good option (just needs to add a gallery).

 

Best Regards,

Levi

Thanks for this solution @DiegoEscobar2 it works as well

Thanks for this solution @v-liwei-msft. It works well, and I realize now that I am working with a sharepoint Integrated list, so I need to do some workaround to ensure my list form works.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (6,682)