cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
kpoxo6op
Level: Power Up

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
Community Support Team
Community Support Team

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
Community Support Team
Community Support Team

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

kpoxo6op
Level: Power Up

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

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Coming Soon: T-shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

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