This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 53%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPV%3C/text%3E%3C/svg%3E)
My path is shared documents/new/Apr/2023/Apr-jun/data xlsx how can I pass these in to the dynamic expression in when a file is created or modified trigger
Same question for me also @Sonny Gillissen @MayankBargali-MSFT did you aware how we can pass the expression here
Hi James James
Thanks for reaching out on Microsoft Q&A!
Assuming you're using the SharePoint trigger for this you could use:
triggerBody()['{Path}']
Please let me know when you have additional queries using the comments below! If my answer was helpful please click "Accept answer".
Kind regards, Sonny
Where can I give above expression on trigger settings or folder place and how can I give yaer and month we did not hardcoded
Ah, see what you mean! Can you highlight the parts of the trigger path that need to be dynamic for me, so I can provide you with the correct answer.
It's dynamic expression along with the year and month
Got it! Then you could use something like this:
concat('shared documents/new/',formateDateTime(utcNow(),'MMM'),'/',formateDateTime(utcNow(),'yyyy'),'/',formateDateTime(utcNow(),'MMM'),'-',subtractFromTime(utcNow(),-2,'Month','MMM'),'/')
We can place these in folder place right if place folder then it will thrown an error folder not found please check your end whether it is work or not
You said add that expression here correct if I add here then it will throw an error folder not found .
Sorry, may have been to early in response. When I come to think of it, you should leave out 'shared documents' as you're already in that library. So then the expression would look like this:
concat('new/',formateDateTime(utcNow(),'MMM'),'/',formateDateTime(utcNow(),'yyyy'),'/',formateDateTime(utcNow(),'MMM'),'-',subtractFromTime(utcNow(),-2,'Month','MMM'),'/')
However, I do think the "apr-jun" part of your folder part can be a bit tricky. Why is it there? And can it be left out perhaps? This makes it challenging to create a dynamic expression for every occasion.
You said add that expression here correct if I add here then it will throw an error folder not found
It was not working again same error
I'm using power autometa not logic app on logic app will able to give dynamic expression but power autometa i did not get any dynamic expression is these possible do in the power autometa
I'm using power autometa not logic apps in logic apps will able to give the expression in trigger is these possible in power autometa
Can I gile file name at the end of expression (/)file.xlsx apr-jun is my folder structure