Wednesday 30 June 2021

Event Registration Form using Microsoft Forms

 In this article, I have tried to give the steps to create the sample Event Registration form. It does not require any code. Without any coding knowledge this can be done.

Pre-requisites: You need to have Office 365 subscription and there is no license needed for Forms, it’s free.

When you login to the Office 365, you have thisicon in the left top corner of the page. It’s called waffle icon. On clicking it you can see all the app that you have permission. In that you will find the Forms (highlighted in the below image).



 To load the Forms click on it. Now you will see the below screen that has “+ New Form” button. Use the new form button to create the Event Registration Form.



Once click the New Form button you will see the blank form with options to create questions and header for the form as shown below.



You need to create as much question as you want to know about the person who wants to enroll themselves for the Event. In this example, I have just created 4 questions like Full name, Email address, Organization and Job Title.

It’s easy to add questions, just you need to click the “+Add Row” button as shown in the below picture.

 



There are some suggestions shown while you are trying to create questions. That’s cool isn’t. You can select from the suggestions list and click “Add selected”. It will be added to your form.

You also have provisions to change the response (Answer) type like choice, text or date etc.

Once you are done with the questions, you need to share it. Before that if you would like to change some setting like who are allowed to enroll for this event, For example: people within the organization or outsiders can also enroll for it. In the right top corner of the page you have Preview, Theme and Share Options also. On clicking the “” you will the menu that contains Settings.



Preview Mode: You can see how the Form looks in Mobile and Desktop view.



Settings: When you go to settings, there are options given for “Who can fill out this form”, there you can select the options according to your need.  Anyone can respond can selected if you are expecting the responses from outsiders also (not part of your organization, they don’t need to login). Anyone from your organization can enroll (respond) if you select “Only people in my organization can respond”. You can also set “only specific people within your organization” can enroll (respond) for it.

Start and End date: You can also set duration from when we can start getting the enrollment (responses) till which date (last date to get the responses).



Theme: There are some list of themes available, you can select anything from the available themes.



Share: After all these, now it’s time to share the Event Registration for to targeted audience. Click on the “Share” button. You have different options like sharing it as short url, QR code, Embedded HTML tag, Email.



 

Responses: Finally now you wish to see how of them enrolled for the event. Check the below options you have for responses. You can also view the results one by one and export the results in Excel on clicking the “Open in Excel” link.



How does the Event Registration form look like?

 Here it is.



 

Now you learnt how to create enrollment form, same steps has to be followed if you wish to create Polling, Survey or Feedback.

Monday 28 June 2021

Fix for Microsoft Forms Button click failed in Power Automate Desktop

 In this blog, I have given the solution for the issue we face while using Microsoft Power Automate Desktop in Microsoft Forms


Problem:
Both Web and Window button click does not work and it throws the below error.


 Failed to press button (failed to get window)

Failed to press button (failed to get window): Robin.Core.ActionException: Failed to press button (failed to get window) ---> Robin.Shared.Runtime.ActionException: Failed to press button (failed to get window)
at Robin.Modules.UIAutomation.Actions.UIUtils.TryFuncThrowExceptionIfNull[T](Func`1 func, ActionException ae)
--- End of inner exception stack trace ---
at Robin.Modules.UIAutomation.Actions.PressWindowButton.Execute(ActionContext context)
at Robin.Runtime.Engine.ActionRunner.RunAction(String action, Dictionary`2 inputArguments, Dictionary`2 outputArguments, IActionStatement statement)

Solution:

 It is actually a work around. Instead of using the "button click" actions, we can use the "Send Keys", when the cursor is in the last control of the form and next is to click on the submit button as shown below. 

Usng the "Insert Special Keys" drop down select the {Tab}{Return} keys in the "Text to Send".

Please try it out and let me know if it worked for you.



Scenarios to use Virtual Table in Dataverse (Power Platform)

Virtual tables in Dataverse provide a way to access extern al data sources without requiring data replication or synchronization. Here are...