web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

How do i trigger flow when a file is uploaded to sharepoint subfolder?

(0) ShareShare
ReportReport
Posted on by 45

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:

  1. Accounts (all accounts)
    1. Account (specific account)
      1. Projects (all projects for that customer)
        1. Project (specific project)

pastedimage1673609548123v2.png

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.

I have the same question (0)
  • Suggested answer
    graemefindlay Profile Picture
    20 on at

    You could do something with a trigger condition that contains '/project/' paired with a trigger condition checking that Isafolder is false.

    pastedimage1676998776859v2.png



    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/')


    Add a condition to prevent triggering when a sub folder is created

    @equals(triggerBody()['{IsFolder}'],false)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Martin Dráb Profile Picture

Martin Dráb 45 Most Valuable Professional

#2
iampranjal Profile Picture

iampranjal 36

#3
Satyam Prakash Profile Picture

Satyam Prakash 31

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans