Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

limit the form submission which has to be updated monthly

(0) ShareShare
ReportReport
Posted on by

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

  • Michael Shen Profile Picture
    on at
    Re: limit the form submission which has to be updated monthly

    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.

     

  • Community Power Platform Member Profile Picture
    on at
    Re: limit the form submission which has to be updated monthly

    Hi Scott,

     

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

    Please advice!!

     

    Regards

  • Community Power Platform Member Profile Picture
    on at
    Re: limit the form submission which has to be updated monthly

    Hi Scott,

     

    This definitely sounds like a solution.

    Need more guidance to implement.. can we connect?

  • ScottShearer Profile Picture
    25,212 Most Valuable Professional on at
    Re: limit the form submission which has to be updated monthly

    @Anonymous 

    Here is how to approach:

    1. Include a column in the SharePoint list with the email address of the submitter
    2. When a new form is submitted:
      1. Use a Get items action to retrieve items from the SharePoint list
      2. 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
    3. 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.

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,660 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow