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:
- Triggers on new mail arrives with attachment
- Create file and save the .xls attachment into Sharepoint
- Convert .xls file into .xlsx file
- Create table on the .xlsx
- Create item in Sharepoint list from the .xlsx file
So far I can only achieve step 2 successfully. 😅 I've tried all these flows one by one separated and they can work with a given file name. But if I want a flow to start from create file, then create table on this file, then use this file to create item in the sharepoint list, it won't work, it always gives me error message showing either "item not found" or "execution of template action fail" with "type null" or something. I think my major questions here are: 1. how to convert xls to xlsx without using 3rd party connector? 2. how to pull a dynamic file name from what's created by the previous step output?
screenshots as below:
