Is there a way to automate the accept responses option in Microsoft Forms? i.e turn it off once a submission has been made, or a certain number of submissions?
We are testing Forms as a daily inspection checklist for a number of vehicles on site.
(The native Teams Inspection App is clunky and its actually broken/unreliable especially on mobile)
When someone does the form I already have automation grabbing the details instantly into dataverse which is fine.
I also have automation which deletes the responses in Microsoft Forms each night using a SharePoint http request, so that when the user does the check the following day, it doesn't say they already did it.
The last issue is that when one person does a check on a particular forklift, it will say to that individual that they have already submitted, however as Forms is intended for surveys or pooling it doesn't let others know it has already been done.
Can I do something like the SharePoint http request to change the form settings, to allow an instant flow to turn off Accept Responses once a submission has been made, with a reoccurring flow each night that turns it back on for the next day?
Then when someone else does the check I can use a Forms custom message that the Form has been completed for today
The below shows what I use to flush out the responses for one particular vehicle, Barney the Forklift. Thankfully I came across this earlier today, is there anything like this for a Forms saved settings anywhere?
Power Automate doesn't have many native Forms connections
Basically trying to reengineer MS services without trying to create something from scratch, if I can get this it should be Ace.
Thankyou
Solved! Go to Solution.
I got it in the end,
I just reverse it each night
I have it triggered on a submission for the form,
You can't see it in the above but I also get the form details and run the name into the form closed message, so it says who has already done it and when each time, then at 23:45 another flow resets and accepts responses for the next day.
Whoop whoop
I messed with it a bit and changed to GET to bring a JSON that actually specifies the line "settings", I just have to figure out how to patch that back in.
I got it in the end,
I just reverse it each night
I have it triggered on a submission for the form,
You can't see it in the above but I also get the form details and run the name into the form closed message, so it says who has already done it and when each time, then at 23:45 another flow resets and accepts responses for the next day.
Whoop whoop
Very helpful! Thanks