Hi Folks,
I am looking for a solution where a person can submit Microsoft form only 4 times in a month and the submission is updated in a sharepoint list item. the 4 number limit has to be renewed every month.
PLease share some insights on how to go about with this.
Regards
The key limit is for MS forms, I guess you can check with Forms team.
For flow(power automate), the trigger is post-action, which means it triggers after submission.
Hi Scott,
I need more help as i have not succeeded in resolving this concern!
Please advice!!
Regards
Hi Scott,
This definitely sounds like a solution.
Need more guidance to implement.. can we connect?
@Anonymous
Here is how to approach:
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.
WarrenBelz
146,660
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,004
Most Valuable Professional