Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Limiting Number of Responses per drop down selection - Microsoft Forms

(1) ShareShare
ReportReport
Posted on by 2

We are using Microsoft Forms to have each department in our organization select if they are operating without issue or escalate when they need assistance. Each department is listed as a drop down on Forms.

For efficiency, we have worked formulas in the background on our TEAMS Excel sheet to pull in the only that day's submissions on a tab and have Conditional Formatting in place to color cells green if all items are good, and different shades of red to show they need assistance.

However, when one department submits twice that day, it will clear all of their selections for that day in our Excel tab. I can easily fix this by deleting one of their entries, but would prefer to block them from being able to resubmit.

Does anyone know how to limit to one entry per their selected department? 

Categories:
  • David_MA Profile Picture
    David_MA 8,929 on at
    Limiting Number of Responses per drop down selection - Microsoft Forms
    You don't show you workflow, so I don't know what you are capturing when someone submits a form. I also don't think this is what you're referring to with regard to limiting to one submission:


    As FL Mike said, based on the information provided, there is no way to do what you want. However, if you are capturing the users e-mail address when they submit the form, record that as part of the request. Then update your workflow to get any items created for the current day by the same user. If they've already submitted something, send them an e-mail that they can only submit one request per day. If they haven't submitted something, do whatever you're currently doing/
  • Suggested answer
    FLMike Profile Picture
    FLMike 29,105 on at
    Limiting Number of Responses per drop down selection - Microsoft Forms
    Hi
     
    No, there is no way to do that.
     
    You said "resubmit" but a resubmit is when they change the Form they did earlier, you are talking about blocking them "period.
     
    You would need to create a SharePoint list of other storage, that would map and track when a specific group already responded.
    In your flow you would check that first then end the flow instead of changing their stuff.
     
    Also youd want to log that you did that.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard