Unanswered

limit the form submission which has to be updated monthly

(0) Share

Report

Posted on by Community Power Pla...

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

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

ScottShearer 25,270 Most Valuable Professional on at

Like (1)

Report
@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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Scott,

This definitely sounds like a solution.
Need more guidance to implement.. can we connect?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Scott,

I need more help as i have not succeeded in resolving this concern!
Please advice!!

Regards

Was this reply helpful? Yes No
Michael Shen on at

Like (0)

Report

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.

Was this reply helpful? Yes No