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

[nhung7]

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

[DiegoEscobar2]

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 · Accepted solution]

Hi @nhung7 

I have made a test for your reference:

1.

2.

3.

Best Regards,

Levi

[DiegoEscobar2]

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]

Hi @DiegoEscobar2 

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

Best Regards,

Levi

[nhung7]

Thanks for this solution @DiegoEscobar2 it works as well

[nhung7]

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.