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

Get all .xlsm files from a folder on sharepoint

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
Solution Sage
Solution Sage

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']

Capture.PNGCapture1.PNGCapture3.PNG

The email would be sent with attachment as below:

Capture2.PNG

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.

View solution in original post

1 REPLY 1
Solution Sage
Solution Sage

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']

Capture.PNGCapture1.PNGCapture3.PNG

The email would be sent with attachment as below:

Capture2.PNG

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.

View solution in original post

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (6,308)