Unanswered

List files in a folder Dropbox

(0) Share

Report

Posted on by AndreiBarta

Hello Power Platform Community,

I want to create a flow that get the metadata of the files that are stored in dropbox folders and subfolders and to put the informations in one sharepoint list, in order to get the metadata of the files from subfolders I used multiple list files in folder actions using the path from the previous action, but I get an error when the list file in a folder action use the path from the previous action and is a file not a folder.

error message:

"The specified resource '/tpa-projects-dev/pl/6q/pc/gg/22_pl333digi_/overview.xlsx' is not a folder."

(see screenshots below)

Categories:

Using connectors

I have the same question (0)

All responses (9)

Answers (0)

Sort by

annajhaveri 8,531 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@AndreiBarta i think you are using file path in the folder path value that is why you are facing the error, try removing the file name from the path and see if that works, you will need to remove file name from path dynamically using following expressions:
replace(item()?['Path'],last(split(triggerBody()?['Path'],'/')),'')

Was this reply helpful? Yes No
AndreiBarta 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @annajhaveri ,
This solution does not work, because I can't choose a dynamic content inside the expression, and if I write the expression i got this error when I run the flow

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@AndreiBarta did you try to use the same expression that i gave?

Was this reply helpful? Yes No
AndreiBarta 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @annajhaveri ,
Yes, and with that expression I got that error from above when I run the flow.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@AndreiBarta okay, so for clarity, can you please add a compose action, just above List files in folder 2 action, assign Path to that compose action. Then use outputs of compose action in the expression instead of
item()?['Path']

Was this reply helpful? Yes No
AndreiBarta 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @annajhaveri
I can't choose the output into expression, because, I think the item Path has more outputs

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@AndreiBarta List files in folder 2 action. is it inside the apply to each action?

Was this reply helpful? Yes No
AndreiBarta 8 on at

Like
a
(0)

Report
Copy link

Link copied!

@annajhaveri yes, because the path for the List files in folder 1 action it's a dynamic one, based on some inputs from sharepoint list

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@AndreiBarta i think there is a better way to do this which is just tested. Add a condition which checks whether the object is folder then get the files from that subfolder, this would make it more clean, please see screenshot below

Was this reply helpful? Yes No