File Directory, not full path with filename

[akharns]

The Path property contains the file name.  I want to store the File Name and the Directory separately.  How can I get just the directory, without the file name?

[abm]

Hi @akharns ,

Follow the below steps:

For the above Compose - FilePath expression is as follows:

replace(variables('FileNameAndPath'),last(split(variables('FileNameAndPath'),'/')),'')

For the above Compose -Filename expression is as follows:

replace(variables('FileNameAndPath'),outputs('Compose_-_FilePath'),'')

Test Results:

If you need any further help please let me know.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

[v-bacao-msft]

Hi @akharns ,

Could you share the specific configuration of Flow?

If the action you are using is List files in folder action, you could consider using the following method to configure Flow.

Expression reference:

first(split(outputs('Path'),outputs('FileName')))

Image reference:

Best Regards,

[Sergio_Carol]

Excuse me, 

How can I access to 'List files in folder'?  (i'm trying to do backup copies of local folders to Onedrive)

Can I read more file's properties (date, size, ...)

Thna you for your answer in advance, 

[abm]

Hi @Sergio_Carol 

Follow this link @yoshihirok solution.

https://powerusers.microsoft.com/t5/Flow-Cookbook/Copy-a-file-from-Local-file-server-to-OneDrive-for...

You can also get the property using Get File metadata property flow action.

If you need any futher help please let me know.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

[akharns · Accepted solution]

Thank you, abm.  My level of expertise on building expressions is extremely limited at this time, but I did get this to work:

1. List Files In Folder

2. Apply To Each

3. Add A Row Into A Table

   In one of my output fields, I used the following:  replace(items('Apply_to_each')['Path'],items('Apply_to_each')['Name'],'')

Your solution sounds interesting, but I don't yet understand how to write a series of steps for "apply to each".  I do eventually need to learn how to use multiple steps with variables and compose, as you have done.  I don't know if my expression above is as simple as it could be, but at least it works.  If you have suggestions on how to improve it, I'm listening.  I was wishing that Expressions would help me more than it did.  I think it has done better in the past, so I must have done it differently this time.

You gave me the idea of using replace and some syntax for doing that.  Instead of parsing the path, I just stripped off the file name.

[akharns]

Correction.  It works in my quick demo, but not in my application.  It must have something to do with how I referenced the fields.  

My application' action is When A File Is Created.  All other fields are pushed from "List of Files", but my syntax is incorrect.

[akharns]

I may have it:

replace(triggerBody()?['Path'],triggerBody()?['Name'],'')

[akharns]

Nope.  Expression accepts it, but as soon as it is shown in the output area, it disappears.  Something's still wrong.

[abm]

Could you please post your flow screenshot?
Thanks

[akharns]

I don't know if this is what you want...

[abm]

Hi
Thanks for your quick reply. I want to see the full flow screenshot starting from trigger to end.
Thanks

[akharns]

[abm]

Hi @akharns 

Thanks for the screenshot. 

You mentioned "Expression accepts it, but as soon as it is shown in the output area, it disappears.  Something's still wrong."

Could you please tell me where you using the expression? Which flow step action and property? I can't see in your screenshot.

Thanks

[akharns]

See the above (1st) screen print.  In "Add A Row Into Event Log", for the "Sources" field, I entered the expression in the Expression builder shown on the right.

[abm]

Hi,

Thanks for the reply. So what you expect in the source field? Lots of questions here. Hopefully we will get there 🙂

[akharns]

I was wanting the source field in the Event Log to have the directory of the created file. My solution was to use the path value, replacing the filename with '', such as replace(triggerBody()?['Path'],triggerBody()?['Name'],''). When I type this in under "Expression" and press OK, it seems to work fine, but then it flashes it into the source field and then clears the field.

[abm]

Hi @akharns 

Could you please tell me which flow action you getting these properties. The below image is from your screenshot.

When I added list files in folder flow step I can't see those properties. Then again I having some issues with my Gateway so that I can't fully test my flow right now. 

Thanks

[akharns]

List of Files Path and List of Files Name

[abm]

Hi @akharns 

I was asking which flow action step you are getting these properties from?

See below these are my properties under List files in folder. As you can see when I filter by text as 'list' no properties are displayed under. You must have a different flow action step here?

Thanks