@Anonymous
Here is how to approach:
- Include a column in the SharePoint list with the email address of the submitter
- When a new form is submitted:
- Use a Get items action to retrieve items from the SharePoint list
- Use a filter query in the Get items action that limits the items returned to items submitted by the submitter in the past 30 days
- If the count of the items is 5 or more, then don't add a new row
Your Odata filter will look something like this:
Email eq 'email from Forms' and Created le 'formatDateTime(utcNow(),'yyyy-MM-dd') and Created gt 'addDays(utcNow(),-30,'yyyy-MM-dd')
FormatDatTime() and addDays() are expressions and must ne entered in the expression window. utcNow() is an expression as well/
Let me know if you need more help.
