Filter array output in create file content

[egornua1]

Hello All,

Hope you may be able to help me.

I have a flow to create files based on customer description.

The final step is to create the new file (xlsx).

Can anyone tell me how to use the output of a filter array as the content of the new file?

Thank you for your time.

[abm]

Hi @egornua1 

Whats the expression under the compose action after the filter array?

Thanks

[egornua1]

@abm - Thanks for taking the time to look at this.

See below screen shots. The compose is to get the description to use in the file name

The compose 2 is the body of the filter array and that output is used in the file content field below

Thank you for the help.

errors here

[abm]

Hi @egornua1 

I can see the latest screen shot File content is changed from SharePoint to output. Is this from the filter step? Also there is a create table as well. Could you please explain bit more about the full requirement?

[egornua1]

@abm  - thanks for the quick response.

I have an excel file with customer orders. I need to group the orders per customer description and then create a file specific to that customer. 

I tried to use filter array output as the file content.

I am then creating an table within each file and populating with the filter array data.

The files are creating but get an error when opening and as you can see the apply to each is greyed out.

Not sure if this is the most efficient way to do this as i'm relatively new to power automate and a non dev.

Thank you

[abm]

Hi @egornua1 

Thanks for your response. After filtering use Create CSV table which is the best option for you.

Thanks

[egornua1]

@abm  i will look at that but i need the files in xlsx output.

Any reason why the apply to each is greyed out, i must be doing something wrong.

Thanks

[abm]

Hi @egornua1 

If you referring to below screen shot then its not greyed out. Flow is till running it and not completed.

[egornua1]

@abm Thanks for clarifying but think there is something wrong.

There is only 5 lines within the excel file and yet the flow is running 10 minutes and times out

The xlsx files create with the correct customer description but there is nothing in the file and get the below error when opening

[abm]

Hi @egornua1 

Check your Excel table rows. You may have too many blank rows.

Thanks

[egornua1]

@abm Thanks for the suggestion.

I checked but only 5 in the table for test purposes.

The 6 row is not part of the table.

Appreciate the support

[abm · Accepted solution]

Hi @egornua1 

Thanks for the screen share. So what we did is after filtering the Excel data added a create CSV table step. Then use create file of SharePoint connector. Under the create CSV table we used the custom table. There we have to convert the date into the below format because Excel dates output as integer in PowerAutomate.

addDays('1899-12-30',int(item()?['Co entry date']),'dd/MM/yyyy')

Another option is under the List Rows of Excel Sheet click the advanced options and set the date as ISO861 then you don't need the above expression to use.

Note: You had an issue with your SharePoint cache and thats the reason it was always showing the old files. If you download the file and open from desktop it was showing the expected results.

Hope the session was useful.

Any questions please let me know.

Thanks

[egornua1]

@abm - Thanks so much for the exceptional support you gave tonight.

Brilliant knowledge of the system and a really nice guy.

You are a credit to this forum and the help you provide really makes a difference to people trying to learn.

Thanks again!

[abm]

Hi @egornua1 

That's very kind of you saying this. There are lots of good knowledge here in this forum. One of the best I would say. 

Thanks a lot