Power automate- xlsx to xls file conversion issue

(1) Share

Report

Posted on by amodtiwari

Hello All,

I am creating a flow to get sharepoint online list records and create xls file for each record.

Followed below process-

1. get items from sharepoint list

2. get excel file template with table definition

3. foreach item in list, create xls file.

4. add row in created xls file to fill 1 row data.

Issues-

At step 4 its throwing error as table not found.

Option-

if i tried to create xlsx file with above steps, its working without any issue. But i need output file format in xls (97-2003) excel version. So after getting xlsx file, i tried to convert it in xls file. File is converting but there is no table data in xls after conversion.

is there any limitation with power automate/office 365 to support xls files with table please?

Is there any way to fill xls file table in power automate that can work?

Is there any other option to convert xlsx file to xls without data loss?

Please help me.

Thanks

Amod

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report
Re: Power automate- xlsx to xls file conversion issue

is there any limitation with power automate/office 365 to support xls files with table please? Is there any way to fill xls file table in power automate that can work? Is there any other option to convert xlsx file to xls without data loss?

yes

no

not in Power Automate. There are paid third party converters that claim to be able to do that.

Was this reply helpful? Yes No
amodtiwari 66 on at

Like (0)

Report

Re: Power automate- xlsx to xls file conversion issue

Thanks for your response. which converter do you suggest to use please for correct response.
I have tried with cloud convert but it was throwing blank xls file as output.

Please suggest.
Thanks

Was this reply helpful? Yes No