Clear format of an array, insert clear info into excel table

[BellaShiu]

I am using "SharePoint-List Folder" to list files in several folders, and I insert those data(file name and last modified time) into a table of Excel using "Excel-Add a row into table".

My flow, the method I use looks like the following:

And the outcome table in excel looks like this:

What I want to do is:

1.clear the format of the array, clear the json format

For exemple, I want data in column "Files" shows like this :

2.see if it is possible to show a clearer view of the files under a folder in a excel table, is there any suggestion to do this

Thanks for any help!

[v-alzhan-msft · Accepted solution]

Hi @BellaShiu ,

Could you please share a screenshot of the configuration of your flow?

For the first question, you could create the variable with string type, and refer to screenshot below to create the flow:

The expression in the Value field as below:

concat(outputs('Compose'),'_',formatDateTime(outputs('Compose_2'),'yyyy-MM-dd'),',')

For the second question, how would you the clear view like? would you please share an example it?

Best regards,

Alice   

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[BellaShiu]

Hi @v-alzhan-msft ,

thanks for your reply for the first question, it absolutely fit the demand.

For "the clearer view" of the files under a folder in a excel table, it means:

I would like to find a better way to show "which files" are in each folder,

for example :

but I have no idea how to design Excel table and flow or design with Power BI to show (for example) this kind(⬆️) of clearer view.

Any idea or suggestions would help, thanks!