Answered

Sharepoint items combine to an excel file

(0) Share

Report

Posted on by juliowastaken

I have a SharePoint list that has a column called Study, I want to be able to export the items related to that study and combine them into one excel file per study. This is the flow I currently have and its exporting all them items into one each study excel file. I don't know where I would need to filter to it combines the studies that are the same and put them items into excel file for that study.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-yetonggu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @juliowastaken ,

I did a test for your reference.

In my scenario:

My SharePoint List:

My Flow:

union(body('Select'),body('Select'))

item()?['Title'] item()?['Status/Value'] item()?['Study']

My CSV File1:

My CSV File2:

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
juliowastaken 75 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much for your help, some studies have attachments.... how can I pull those attachments associated with that study and some studies have multiple people assigned to them in different cities... how can I take it a step further and filter based on study and coordinator. I really appreciate your help.

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @juliowastaken ,

If my reply solves your original problem, please mark my reply as the solution.

For your new problem, I suggest you open a new post and add more detailed descriptions, so that it will be viewed by more people.

People can see it and improve the efficiency of solving your problems.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No