
Announcements
Hi,
I have tried with no success for a long while in figuring out how to limit the registration responses.
I have a Microsoft Form that will be used for registration soon and it has a live online Excel Response File. I want to limit the registration to 100 people that respond to question field "Do you have a book?" with their answer of "Yes I do" Once 100 people have responded with "Yes I do," I would like any any further responses received after them to receive an email saying, the session is full.
I hope someone can kindly help me. It would be much appreciated.
-
Hi @MelindaG,
It's unfortunate the ODATA filter query Contains is not supported in the Excel connector.
You could do it with the help of Filter array action, for example:
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.