
I'm used to working with power automate and dynamics, but I've not worked with power automate+sharepoint, so maybe my question is a bit too basic here.
What i want to do is update a field on a project when a file is uplooaded to the sharepoint of that project.
The folders are on each account that have a project on them, so the map structure is this:
So what would be preffered is to trigger the flow when that last folder gets something uploaded into it. In power automate you can choose which library and which folder to choose from, but how can I make this dynamic? So my thought is to have it like /account/DYNAMIC/project/DYNAMIC, can I somehow choose to only trigger when the 3rd folder after account is updated or do i need to do this in later steps in the flow?
Right now my flow is always triggered whenever something is uploaded in the account folder (first one), and even multiple times if what is uploaded is a folder with items in it. So for a folder with 2 items in it the flow is triggered 3 times, which isn't optimal.
You could do something with a trigger condition that contains '/project/' paired with a trigger condition checking that Isafolder is false.
You would then need to extract the folder name string from the path to identify the project you want to update in dataverse.
replace '/Level 3 folder/' with the static name of your own level 3 folder
@contains(triggerBody()['{FullPath}'],'/Level 3 folder/')@equals(triggerBody()['{IsFolder}'],false)