Table or render tools outputting HTML into excel sheet

[shamv]

Hi all,

I am using designer version  2021.4.2.

I am taking three separate files from my sharepoint library and pushing them to an excel. I want to format the output header names and background so have used the table tool. However, when outputting, it shows the html rather than the data required in the sheet as below:

I have attached my workflow, I have also tried using the render tool, but this doesnt work either, it throws the same error,

Any help appreciated,

Thanks

[gautiergodard]

hey @shamv 

the reason for HTML showing up is that you are using a regular output tool.

you'll need to replace those and create the excel output using a "render" tool from the reporting tool pallet.

hope this helps!

[shamv]

Hi Gautiergodard

As above - Ive tried the render tool, but this doesnt work either unfortunately; also the render tool doesnt allow to push data to individual sheets in excel. For testing purposes I tried Render tool but I wont be able to use it

Thanks