Capture an Excel file from an e-mail and edit that XLS

(0) Share

Report

Posted on by Flow-Fiesta

Hello everyone!

This is my first post! I'm a newbie in using Power Automate, so I ask for your patience! I need to automate the following task:

I receive an Excel file (old format .XLS) in an email.
I need to capture that XLS file and edit some cells that I currently modify with a manual macro (they are minor changes, like removing a slash, etc.).
Transfer all that information to a SharePoint list.

** Important ** Every time a new email is received, the SharePoint list should be replaced with the new data (old data should not be retained).

Can someone help me achieve this? I've been practicing step 1, but I don't know how to capture the attached file (xls) and edit it. I would be extremely grateful if someone could help me with this!

Thank you very much.

Flow-Fiesta

Categories:

General topics

All responses (5)

Answers (0)

Sort by

lbendlin 8,726 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

You can't do anything with .XLS format files. You need to convert to XLSX first.
Flow-Fiesta 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @lbendlin thanks for your help!
Do you know if there's official documentation stating that Power Automate can't handle XLS files?
I can't use either the Standard or Premium connectors due to company security policies; otherwise, the automation would already be resolved.
Someone mentioned Microsoft Graph to me, but honestly, I don't know anything about the tool, and I'm not sure if it really helps with converting xls to xlsx.
Do you have any ideas for automating this file?
Thanks for your help.
lbendlin 8,726 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

This link , bullet point #4 (note how they misspelled .xlsb)

Excel Online (Business) - Connectors | Microsoft Learn

The basic takeaway is that the cloud flows can only work withOpenXML formatted files. There exist (paid) connectors that claim to be able to convert .xls into .xlsx - I have no experience with these.
Flow-Fiesta 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your help @lbendlin 💪
Suggested answer

takolota1 4,980 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

If you want to get data from a sheet on an XLS file, then this Azure Function template may work: https://community.powerplatform.com/galleries/gallery-posts/?postid=eea06380-8483-ef11-ac21-7c1e5201b42f