web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate When I add a Folder/Su...

Power Automate

Answered

When I add a Folder/Subfolder/file in Sharepoint, I want the path of that file to be set in columns automatically

(0) Share

Report

Report

Posted on by C1ck

4

Hello,

I'm new to power automate

I'm having this issue where I can't figure out how should I add the path in columns using Power Automate:

for example:

Test/testing/powerautomate.txt

this is the output that I want:

I'm not sure if I'm wrong but this is what I did so far...
I'm confused on what to write in the body

Thank you.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report
Copy link

Link copied!
Hi @C1ck ,

I've made a test for your reference:

split(triggerOutputs()?['body/{Path}'],'/')[sub(length(split(triggerOutputs()?['body/{Path}'],'/')),3)]
split(triggerOutputs()?['body/{Path}'],'/')[sub(length(split(triggerOutputs()?['body/{Path}'],'/')),2)]

Best Regards,

Bof

Was this reply helpful? Yes No
C1ck 4 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-bofeng-msft ,

Thank you so much. It worked!

Regards

Was this reply helpful? Yes No

Join the conversation