Use Powerautomate to schedule export of SharePoint List to Excel, but list has multi select drop Down

Question

Hi there, I have a SharePoint list that I would like to backup every week to an Excel file stored in SharePoint. I can do this relatively easily but the problem comes as the list has multi-select drop downs. I am just unable to get the multi-selects to populate properly in Excel.

As per the image below I initialize an array, and then want to append the Multi-Select values to the array. In my example, my multi select column is called "Mult select". But I dont get the option to to choose the values for "Mult Select". This option does show up if I trigger the flow with the Sharepoint trigger "When an item is created or modified", but not with a "Recurrence" trigger. It is driving me crazy. Some help really appreciated.

Answer 1

Dear John,

Good day!!

I understand your concern and to my knowledge, I believe it requires some addition expressions and since it’s related to the customization of Power Automate flow, I suggest you to post your concern in the Microsoft Power Automate Community - Power Platform Community to get the detailed help from the experts.

Apologies for redirecting you to different community as the members in the category posted focus on the users with the Microsoft 365 concern and have limited knowledge on the customization of Power Automate flow, so to get the fast and better assistance, we have redirected you in the correct path.

Thanks for your patience and understanding. Have a good day!!

Best Regards,

Sophia