Hello,
I have a rather large document library (136,979 items) in SharePoint. I was tasked to create a Flow that essentially sends out different e-mails depending on what is in the "Status" column.
This Flow does a few more things that are unimportant to this troubleshooting. I was able to successfully create the logic and structure of the entire Flow in a "sandbox" document library in SharePoint using my personal Flow account. Once I finished testing all the different features in my sandbox environment, I began to create the production-ready Flow on my company's service account. I started by connecting Flow to the large production document library in SharePoint and quickly tested the connection but it did not work. (I tested the connection by simply adding one e-mail step after the "When an Item is Created or Modified" trigger then I modified an item in the library but did not receive the e-mail)
The error is as follows:
{
"status": 400,
"message": "This operation requires Modified field to be indexed but current user does not have permissions to create it automatically.\r\nclientRequestId:..."
}
Upon seeing this error, I went into the document library's Settings > Indexed Columns then proceeded to index the "Modified" field. This did not fix the issue.
Is the document library perhaps too big? I have been troubleshooting for several hours now but I'm unsure of where to go from here. I was able to create everything just fine in a sandbox enviornment but when it came time to replicate it in the (much larger) production enviornment, I can't even get the initial connection established.
Thank you.
