cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BellaShiu
Microsoft
Microsoft

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

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:

original.png

flowlookslike.png

And the outcome table in excel looks like this:

Annotation 2020-04-23 121024.png

 

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 :

Annotation 2020-04-23 121421.png

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!

 

  

1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

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:

1.png

 

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.

 

View solution in original post

2 REPLIES 2
v-alzhan-msft
Community Support
Community Support

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:

1.png

 

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.

 

View solution in original post

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:

Annotation 2020-04-24 103645.png

 

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

for example :

sfcszdf.png

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!

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (3,030)