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:
- Accounts (all accounts)
- Account (specific account)
- Projects (all projects for that customer)
- Project (specific project)
- Projects (all projects for that customer)
- Account (specific account)
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.