Answered

Alert when file added to SharePoint and how many files and where

(0) Share

Report

Posted on by mvaladez

112

So I discovered I can automate Dropbox to Sharepoint and create an alert when adding a new file. What I'm wondering is can I base that alert on say 50 files was uploaded today and these are the locations?

All responses (16)

Answers (1)

mvaladez 112 on at

Like (0)

Report

Re: Alert when file added to SharePoint and how many files and where
grantjenkins 11,059 Super User 2025 Season 1 on at

Like (0)

Report

Re: Alert when file added to SharePoint and how many files and where

Are you able to go into Site contents and see how many items are in the library? That error generally indicates that you have a lot of items in a list/library.
mvaladez 112 on at

Like (0)

Report

Re: Alert when file added to SharePoint and how many files and where

Got this error "The attempted operation is prohibited because it exceeds the list view threshold."

I created it exactly how you posted it and it worked flawlessly until like 1 day last week. I have daily emails showing it was working. Only reason I knew it didn't work was because on the no part of the condition I had it sent out an email stating that nothing was uploaded.

So beginning of the week when I looked into it, I created a new flow following the same steps and nothing.

I could possibly try it on my other account and see. Appreciate you still helping me to resolve this matter.
grantjenkins 11,059 Super User 2025 Season 1 on at

Like (0)

Report

Re: Alert when file added to SharePoint and how many files and where

What if you remove the Filter Query completely - does it return results then?

Do you have a Trigger condition set on your Trigger? Just trying to understand why nothings coming back.
mvaladez 112 on at

Like (0)

Report

Re: Alert when file added to SharePoint and how many files and where

Tried this and still nothing. I even tried a new folder location with 1 folder and threw in 10 photos for a quick test and nothing.
grantjenkins 11,059 Super User 2025 Season 1 on at

Like (0)

Report
Re: Alert when file added to SharePoint and how many files and where

Are you able to change the Filter Query on your Get files to below just to see if any files returned now. It should now return files from the last 5 days.

FSObjType eq 0 and Created ge '@{addDays(utcNow(), -5)}'

I'll do some testing and see if there are any limits to the number of folders, etc.
mvaladez 112 on at

Like (0)

Report

Re: Alert when file added to SharePoint and how many files and where

Created a test folder with just a few files and the same issue. So something has changed which I don't know or understand.
mvaladez 112 on at

Like (0)

Report

Re: Alert when file added to SharePoint and how many files and where

Nope
grantjenkins 11,059 Super User 2025 Season 1 on at

Like (0)

Report

Re: Alert when file added to SharePoint and how many files and where

In your Get files can you set Top Count to 5000 and see if you get results back?
mvaladez 112 on at

Like (0)

Report

Re: Alert when file added to SharePoint and how many files and where

2,595 files, 189 folders