Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Send notification when file is added to Sharepoint

Posted on 25 Nov 2024 17:05:41 by 4
Hello!
 
I am trying to build a power automate to send an email notification whenever a file is added to a SharePoint folder. I was able to do that by adding a trigger "When a file is created (properties only)" and then a "Send an email (V2)" action. However, I need to refine this automation to trigger only when a file is added to the main folder, but not when a subfolder (with items within it) is created.
 
I tried to add a condition to specify the File Path or Full Path but it didn't worked as I wanted, maybe because I am not very sure about the difference between these two conditions. 
 
Can someone please help? Thank you in advance!
  • Chriddle Profile Picture
    Chriddle 7,056 on 28 Nov 2024 at 10:06:24
    Send notification when file is added to Sharepoint
    This is only triggered if the path is “Shared Documents/”:
     
    @equals(triggerOutputs()?['body/{Path}'], 'Shared Documents/')
     
  • SharonS Profile Picture
    SharonS 164 on 28 Nov 2024 at 09:10:44
    Send notification when file is added to Sharepoint
    Do you have any value in any of the columns that ONLY the desired folder uses?  If so, use that column in the condition and say "is equal to" then the value that only that folder would use.
     
    That would be the condition.
     
    If that condition is met then the Yes side you'd send an email to the user(s).
     
     
     
     
  • vcc1 Profile Picture
    vcc1 4 on 25 Nov 2024 at 20:48:06
    Send notification when file is added to Sharepoint
    Hi SharonS, thanks for your reply!
     
    Unfortunately, I cannot modify how my Sharepoint folders and items are currently built. It is standardized across my whole organization. This Sharepoint site specifically I don't even have permission to change any settings, only view the files there. Is there any other way I can accomplish my goal without changing the current structure that my site has?
  • SharonS Profile Picture
    SharonS 164 on 25 Nov 2024 at 17:16:25
    Send notification when file is added to Sharepoint
    Instead of using folders use metadata.  Take each file out of the folders.   You can name your column "Folder Name" then have the values in that column the folder names.  Then for each item, have the user select the metadata for the folder name.  Folder Name column has to be a mandatory field.  Then in your flow your condition will be When Folder name is equal to Project 1, send email.....
     
    Folder Names:
    Project 1
    Project 2
    Project 3
     
    Each file in that library will be tagged a folder name

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,246

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,884

Leaderboard