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!
Solved! Go to 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.
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.
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!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
67 | |
24 | |
16 | |
16 | |
13 |
User | Count |
---|---|
116 | |
35 | |
32 | |
28 | |
26 |