Unanswered

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

I have the same question (0)

All responses (5)

Answers (0)

lbendlin 8,474 Super User 2025 Season 2 on at

Like (1)

Report

You can't do anything with .XLS format files. You need to convert to XLSX first.

Was this reply helpful? Yes No
Flow-Fiesta 16 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
lbendlin 8,474 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Flow-Fiesta 16 on at

Like (0)

Report

Thanks for your help @lbendlin 💪

Was this reply helpful? Yes No
Suggested answer

takolota1 4,974 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No