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.

 

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
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

Users online (2,069)