Forum Discussion

denisemartincaldareri's avatar
denisemartincaldareri
Copper Contributor
Feb 03, 2020
Solved

Validate entries in Microsoft Forms

Hi, everyone! 

I have created a form that connects with a flow of Power Automate. I would like to know if there is any way I can validate the answers given by the responder before he submits them. In particular, I would like the responder to write two times his email address and check if these answers are equal. I need to validate the address since the flow will later on send emails to the responder.  This person is not necessarly part of the organization so he may not have Microsoft account, therefore, this information is not saved by Microsoft Forms by default. 

Thank you in advanced!

  • denisemartincaldareri this doesn't exist as functionality at the moment. The most you can do is add a restriction to your text question and set it as an email address field. You could add the question in a second time but you can't validate it against the first question.

16 Replies

  • Jack_Chen645's avatar
    Jack_Chen645
    Copper Contributor
    I also want a function that the Form can support to validate the input through a list. The list is not visible to the users but can reminder the user if the input is not in the list. e,g. Only the users whose employee ID is in a pre-defined list can fill the Form.
    • GregWoodsLancs's avatar
      GregWoodsLancs
      Copper Contributor

      LinusBetschart 

       

      It is such an obvious feature! And a typical Microsoft omission.

      If you make a list of top 10 things you'd want out of a Form... near the top of that list would be Email format validation and Phone format validation. But I doubt we'll ever see it. Once Microsoft flag a product as "finished" they forget abhout it and move on.

      • glenn140's avatar
        glenn140
        Copper Contributor

        GregWoodsLancs 

        I agree, I actually was just looking for instructions on how to basic validation (we want to limit submissions to a specific epost domain).  I just assumed you could do that....

  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor

    Hi denisemartincaldareri 

     

    In addition to Megan_V_Walker 's response, what type of validation are you seeking to the questions?

     

    Have you looked at doing a Quiz where you can specify the right and wrong answers and put some restrictions to narrow down the users given input?

     

    Forms does have limitations with validation more complext than this, but it's a good start in case you haven't explored the options yet.

     

    Cheers

    Damien

    • denisemartincaldareri's avatar
      denisemartincaldareri
      Copper Contributor

      Damien_Rosario Thank you, I used other field types like "option" to limit errors but in this case I needed to make sure that the responder typed correcty his email.

  • denisemartincaldareri this doesn't exist as functionality at the moment. The most you can do is add a restriction to your text question and set it as an email address field. You could add the question in a second time but you can't validate it against the first question.
    • VFX_Pro's avatar
      VFX_Pro
      Brass Contributor

      Megan_V_Walker 

      Thanks Microsoft for failing to provide an appropriate powerful solution after retiring InfoPath.  Microsoft forms is so basic it's barely usable in any website. Google forms, Cognito forms are way more powerful.

       

      Date/time validation, Visiblity, Conditions, Rules, regex (social security number, phone number)

      • glenn140's avatar
        glenn140
        Copper Contributor

        It really is mindboggling that they don't have this functionality as there are all kinds of use cases for this.  When I first looked into this question I just assumed that an option to validate a field was there and that I just couldn't find it.  VFX_Pro 

Resources