Limit Registration in Forms - using Live online Excel Response File

(0) Share

Report

Posted on by MelindaG

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.

All responses (1)

Answers (1)

Verified answer

v-litu-msft on at

Like (0)

Report

Re: Limit Registration in Forms - using Live online Excel Response File

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.