cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Export Multiple Multiselects

Hello all, I need to export Sharepoint Online List to CSV file with Flow.

 

 

 

 

Here is my list:

 

+------------------------------+---------------------------------------------+-------------------------+
| Filename (String)            | Product (Multiselect)                       | User Type (Multiselect) |
+------------------------------+---------------------------------------------+-------------------------+
|                              |                                             |                         |
+------------------------------+---------------------------------------------+-------------------------+
| Settings_m1_h.asp            | MP_ENG_01; MP_ENG_02; MP_BMO_01; MP_GOC_01; | 105; 106                |
+------------------------------+---------------------------------------------+-------------------------+
| settings_m1.asp              | MP_BMO_01; MP_ING_01;                       | 105; 106                |
+------------------------------+---------------------------------------------+-------------------------+
| settings_p1.asp              | MP_ENG_01; MP_ENG_02; MP_VIS_01;            | 105; 106; 107           |
+------------------------------+---------------------------------------------+-------------------------+
|                              | MP_GOC_01; MP_BMO_01                        | 105                     |
+------------------------------+---------------------------------------------+-------------------------+
| /main/transaction_l_2_cd.asp | MP_GOC_01                                   | 105                     |
+------------------------------+---------------------------------------------+-------------------------+

 

 

 

Here is my desired CSV file I woould like to generate ( just export list "as is" 😞

 

+------------------------------+---------------------------------------------+-------------------------+
| Filename (String)            | Product (Multiselect)                       | User Type (Multiselect) |
+------------------------------+---------------------------------------------+-------------------------+
|                              |                                             |                         |
+------------------------------+---------------------------------------------+-------------------------+
| Settings_m1_h.asp            , MP_ENG_01; MP_ENG_02; MP_BMO_01; MP_GOC_01; | 105; 106                |
+------------------------------+---------------------------------------------+-------------------------+
| settings_m1.asp              | MP_BMO_01; MP_ING_01;                       | 105; 106                |
+------------------------------+---------------------------------------------+-------------------------+
| settings_p1.asp              | MP_ENG_01; MP_ENG_02; MP_VIS_01;            | 105; 106; 107           |
+------------------------------+---------------------------------------------+-------------------------+
|                              | MP_GOC_01; MP_BMO_01                        | 105                     |
+------------------------------+---------------------------------------------+-------------------------+
| /main/transaction_l_2_cd.asp | MP_GOC_01                                   | 105                     |
+------------------------------+---------------------------------------------+-------------------------+

 

 

 

 

Here is my flow:

 

test flow 1.png

 

 

 

 

 

Here is my actual output file:

 

+------------------------------+-----------------------+-------------------------+
| Filename (String)            | Product (Multiselect) | User Type (Multiselect) |
+------------------------------+-----------------------+-------------------------+
|                              | []                    | []                      |
+------------------------------+-----------------------+-------------------------+
| Settings_m1_h.asp            | @odata[Product]       | @odata[User Type]       |
+------------------------------+-----------------------+-------------------------+
| settings_m1.asp              | @odata[Product]       | @odata[User Type]       |
+------------------------------+-----------------------+-------------------------+
| settings_p1.asp              | @odata[Product]       | @odata[User Type]       |
+------------------------------+-----------------------+-------------------------+
|                              | @odata[Product]       | @odata[User Type]       |
+------------------------------+-----------------------+-------------------------+
| /main/transaction_l_2_cd.asp | @odata[Product]       | @odata[User Type]       |
+------------------------------+-----------------------+-------------------------+

@odata[Product] is a long string which looks like this:

 

Spoiler
[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"MP_ENG_01"},{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":1,"Value":"MP_ENG_02"},{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":4,"Value":"MP_BMO_01"},{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":5,"Value":"MP_GOC_01"},{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":6,"Value":"MP_ING_01"},{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":7,"Value":"MP_STI_01"},{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":9,"Value":"MP_USB_01"},{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":10,"Value":"MP_UMB_01"},{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":11,"Value":"MP_VIS_01"},{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":12,"Value":"MP_VIS_03"}]

@odata[User Type] is a long string which looks like this:

 

 

Spoiler
[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"105"},{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":1,"Value":"106"}]

I tried to iterate through each multiselect etc but it didn't work. How do I generate desired CSV file?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Export Multiple Multiselects

Hi @kpoxo6op ,

 

I have made a test on my side and couldn't find a way to create a csv table with Multiselects column, I'm afraid that there is no any easy way to achieve the requirement in microsoft flow currently.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Export Multiple Multiselects

Hi @kpoxo6op ,

 

I have made a test on my side and couldn't find a way to create a csv table with Multiselects column, I'm afraid that there is no any easy way to achieve the requirement in microsoft flow currently.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
New Member

Re: Export Multiple Multiselects

Thanks for investigating for me Alice, maybe you can point me tho the right direction.

The List I mentioned lives on other team's Sharepoint Online page.

 

What I need to do is:

1. login to Sharepoint Online

2. read the List programmatically into a string/object/file on schedule

3. do some text transformation with the result

4. generate a file with the transformed text

 

Maybe there is a PowerShell module for that?

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,467)