My company uses SharePoint List Item Comments regularly and we are running into an issue where if someone does not use an @mention within the comment, we are never notified of the comment. My goal is to have a flow that checks for these comments and sends us a notification if a comment is added without an @mention. I originally wanted to do this on Item Modified but based on my research, this may not be possible. So now I am going to do a Recurrence flow.
I want to run a Get Items with some filters. All items that come back will have the Comment section checked and if the newest comment does not include @mention, then it will send an email. Currently it is failing.
In the Select:
Name: item()['author']['name']
Date: formatdateTime(item()?['createdDate'], 'dd MMM yy')
Text: item()?['text']
After this, it sends the email off and moves onto the next item.
This however runs for a while and fails with a BadRequest
How can I fix this? It seems my Select options should be different.
Anything helps. Thanks!
