Hi All,
I was wondering if anyone has experience of using Power Automate to add an excel content into a sharepoint list.
What I'm trying to do is this - I want to update a sharepoint list by adding in some new records every day by Power Automate, datasource is a recruiting system where I can set an automated report to be sent out as a .xls file to certain mailbox. The trigger is a new mail with attachment arrives in this shared mailbox (which I applied only for this reporting purpose), and I can now pull and save the attachment into the Sharepoint document library, I believe the automate steps should be like this:
@v-litu-msft Thank you for the reply, I've looked into the UR flows connector and it needs an install of a gateway on local drive, which seems quite complicated. I'll skip this for now and get the report "saved as" .xlsx before it's imported into sharepoint. But thank you for your kind instruction anyway!
Hi @Cristinacn,
1. There is no action that could convert xls file to xlsx file, but you could use UI Flow to do it. There is a template you could do it: Convert .xls files to .xlsx using UI flows | Microsoft Power Automate
This is a blog about how to create a UI Flow that convert xls file to xlsx, please refer to it:
Convert XLS files to XLSX files using UI flows - Power Platform Community (microsoft.com)
2. You could use Get file properties action to get the file name created by the previous step output.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Michael E. Gernaey
566
Super User 2025 Season 1
David_MA
516
Super User 2025 Season 1
stampcoin
492