Get all .xlsm files from a folder on sharepoint

[FJSF]

I'm doing a project, and I'd like to automate it, I'd like to know a way to fetch all exel files, without having to "get file content" for each one, because if you add another exel file or rename it It will not return anything.

What I'm doing is: Every week (Tuesday) he sends the update of the files from sharepoint to outlook email. 

[v-zhos-msft · Accepted solution]

Hi @FJSF ,

You want to get all .xlsm files from SharePoint, then send them to outlook email. 

I have made a test on my side, please take a try with the following workaround:

The expression of ContentBytes as below:

body('Get_file_content')?['$Content']

The email would be sent with attachment as below:

You could also refer to link below to learn send an email with multiple attachments:

https://preview.flow.microsoft.com/en-us/blog/multiple-attachments-single-email/

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.