Forum Widgets
Latest Discussions
Mircosoft forms email
Hi - I have set up an internal reporting system using microsoft forms - all works well - have built power automate to direct reports to the right teams. The only thing I can't figure out is why each report comes with my email rather than the email of the reporter? I know the answer must be simple as it is forms - but I can't work it out. Any ideas? Thanks Noy
This form can't be distributed as it is asking for personal or sensitive information
Two issues, one with what the system flagged, and the second with how the system is not designed to help you correct the error. First Issue: It took me an hour of clicking in form fields and making minor text changes to get the system to momentarily clear the error and allow me to make a copy of the form for rough cut deletion of the offending section. That was a pain and part of what I will get into in part 2. When I finally had a copy I could work with, I deleted sections until I got to the question “EA Passes” with the subtext “how many Early Access Passes does your crew need”. This was the offending question. EA Passes. I changed it to EA Games, EA Medical, EA Social Security… these were all fine. But “EA Passes”. Flagged. This is not sensitive info, you may wish to have your system let that one go. Second Issue: and this is user satisfaction related. The system flags and makes the entire form unusable rather than flagging the individual question or phrase. Having a helpful popup showing what is flagged and making the form usable without this question would be wonderful! Especially considering the fact that the term flagged was not clear or even remotely sensitive in nature. Thank you for considering 1. The flagging of “EA Passes”, I changed this to Early Access Passes to get past it, and 2. Some help fixing/flagging the issue/phrase rather than dynamiting the form and forcing you to delete most if not all of your work to try to find the issue.
Custom Validation in Forms
Hi, I have a text field in forms, and I was wondering if I could do some kind of custom validation or multiple validations (i.e. 1 AND (2 OR 3)) on that text field. I feel like I have seen custom validation functionality (e.g. RegEx) before but this is not available in my version of Microsoft forms. Suppose it is only available in another version of Forms (i.e. Pro), is it possible to request for this functionality to exist in the normal version? The reason why I cannot use power automate or what not to post validate is because I do not collect E-mails (Not because I don't want to, but because my users simply don't have one or do not maintain one).
Excel Does Not Sync Until Opened
I created a form linked to an Excel spreadsheet in SharePoint as well as a Power Automate approval flow triggered on submission. In addition to sending out confirmation/approval emails, the flow also updates the associated Excel spreadsheet with the approval/denial. The flow was working fine until last week but since then has failed 2 consecutive times. The failures appear to be related to the flow unable to find the automatically generated submission ID in the Excel spreadsheet. When I open the linked spreadsheet, the submission is not immediately present at first but the file does sync at that point and the entry appears. When re-triggered after the sync, the flow completes successfully. Not sure if it is related, but MS form/linked spreadsheets have been updated by Microsoft recently and I was prompted to go through an update process for synced Excel spreadsheets. I completed the update with this specific form last week after the flow failed for the first time. TLDR - my form only syncs with the spreadsheet once opened. Any ideas how to get MS Forms to update the spreadsheet in real-time as opposed to when it is opened?
Using comma as separator in Forms
I live in The Netherlands and we use a comma as a decimal separator. However when I use Microsoft Forms it doesn't accept the comma, it removes it. See below. Both Windows and Google Chrome have the right regional settings, namely Dutch. The strange thing is that when I do the same in a Sharepoint list, it works correct. So the problem seems to be with Microsoft Forms. Any ideas anyone? ps I have also set the primary language to Dutch.
Microsoft Forms (Require Number in Text Field)
Hello Everyone, I'm sure this probably a really simple question but how do I get Microsoft Forms to require a number entered as a text answer? The reason i'm asking is because I want to make an order form for monitor replacement for my school district but i'm finding that since its a text box they can enter anything. I had 3 responses that had questions and notes tacked into them and want to limit that for the future. Thanks
Can multiple users fill out the same form?
I am looking to create a form that multiple users can fill out: For commercial purposes, I am seeking to fill out the first two questions of a given form. I want to then submit those answers and send the form to a third party (with a notification) for them to fill out the remaining questions of the form. Finally, I want them to be capable of sending through the remaining answers back to me. Is the above realizable through Microsoft forms?
