MS Forms: Create Quiz quick and easy

What it is?

For introduction on what is MS forms and to get started with MS Forms, refer previous article on MS Forms.

Getting Started with Quiz using MS Forms

Note: Currently, while this article is being written, Microsoft Forms is available for only First Release customers.

  • Login to your Office 365 account
  • From the Navigation bar, select “Forms” as show below:

1_1

Creating your first form:

  • Creating a new form is pretty easy. You can either create “New Form” or “New Quiz”. Click on “New Quiz

2_1

  • Form Design area has two main sections-

Questions: Where you can design the form, add questions, attach images etc. The form you design here will be presented to the end users

Responses: This is the result area where all responses will be analysed and presented

2_2

  • Click on the “Untitled quiz” section and enter Title and Description of the form. You can also attach images. Images can be imported form 3 locations:
  1. Image search using Bing Search
  2. OneDrive
  3. Upload from your local machine or network drive
  • Enter Title a title and Description.
  • Click on “Add Question” it will present option of Field type as below:

1_5

  • Click on “Text”. It will add a text field with an option to enter “Question” value. Your questions can be configured with variety of options based on data type selected.

2_3

  • For any particular option , there are few options which can be configured as below:

2_4

  • Add more questions as required.
  • I created a simple quiz with below fields

2_5

  • Once you are done designing the form, click on “Share” from top navigation to get options of how the form can be shared with either users of your tenant or anonymous users

1_8

  • From the “Send and Collect Responses” dropdown, select “Anyone with the link can respond” and click on “Copy”
  • Now you are ready to present you form to users. Quick and easy!
  • When user will access this quiz and submit the answers, user will get result of the quiz as below:

2_6

View and Analyse Response

  • To view response, open the form and click on Responses Tab. You can see the total count of response received in tab heading itself also, the average score based on total responses would also be displayed.

2_7

  • Also, for choice fields, it automatically creates visual representation in form of Pie charts based on responses received.

2_8

  • You can also view the responses in excel. And save it for further analysis or exporting.
  • To review the answers, click on “Review Answers” You can review answers in two ways, either review according to “Person” or Review according to “Questions”
  • When you review by “Person”, it will Show response of each and every respondents individually. It will give details like Name, Time taken to complete the quiz, his score and is replies to each questions.

2_9

  • When you review by “Questions”, it will give details of average score for that question, count of responses received against each options (clicking on which will give a popup containing details of all respondents who selected that option).

2_10.png

Conclusion:

Microsoft Forms is very nicely designed and users can create forms and quiz very easily and quickly. It will save a lot of time and the biggest plus points is all responses are analysed pretty well.

Advertisements

MS Flow and Trello Integration

MS Flow allows you to create automated workflows between your favorite apps and services to get notifications, synchronize files, collect data, and more.

Trello is a web-based Project Management application. It is incredibly flexible and easy to use. It keeps track of everything from big picture to the minute details.

This article assumes that you already have MS flow account and Trello account.

MS Flow connectors:

MS Flow provides around 72 connectors which make connecting to various Apps such as SharePoint, Office 365, Twitter, Facebook, SQL, Google Calendar and many more. To get full list of available connectors, visit https://flow.microsoft.com/en-us/services/

Trello data can also be accessed using Trello connector. In this article we are going to explore the same.

Connect Trello to MS Flow:

  • Create a SharePoint List with Name “Trello”. Rename “Title” field to “Card Name” and add a new column with Single Line of Text with Name “CardDescription”. Rename it to “Card Description” afterwards.
  • Access MS flow from Office 365 app launcher or visit https://flow.microsoft.com/en-us/
  • Click on “My Flows” from top navigation
  • Click on “Create from Blank” as we will be starting from scratch
  • In the next screen you will see a list of all available actions to choose from. Type in “Trello” in the search box to get options of operations available with Trello3
  • It would ask you to Sign in to create connection to Trello. Click on “Sign In” and enter your credentials.
  • Once you enter your credentials, it will ask for permissions as below:5
  • Select “MS Flow Test” board from the list9
  • Click on “New Step” and Select “Add An Action”. Select “SharePoint – Create Item” action from search list.
  • In “Site URL” textbox, enter SharePoint site URL and select “Trello” list from “List Name” dropdown.
  • It will populate columns from “Trello” list. Now we have to bind details which we want to populate from Trello board into the SharePoint List.
  • Select values as shown in screenshot below:Trello
  • And we are done! Click on “Create Flow” and once it is completed, it will display message on top “Your flow was created. To exit, click “Done”. Then Click on Done.
  • You can manage newly created flows by clicking on “My Flows” from Top Navigation.
  • Now enter new cards in “MS Flow Test Board” with Name and Description and you will be able to see those entries added in “Trello” SharePoint list.8Happy SharePointing!!

SharePoint Debugging : Determine which worker process to attach while debugging

Most of the times, during SharePoint debugging,we see that while trying to attach to process “w3wp”, many process with same name are listed.

How to determine which process we need to attach to? As the dialog box does not contain Application Pool details. Follow the steps given below to easily identify the correct worker process.

  1. Open the Command Prompt with Administrative Privilege
  2. Change the directory to c:\Windows\System\Inetsrv
  3. run “appcmd list wp“. It would list all the worker processed with ID and application pool information:

apppool

4. Find out process ID associated to the web application pool you want to debug.

5. Go back to Visual Studio “Attach to Process” dialog box and associate to correct process with ID we got in Step # 4.

Happy Debugging!!!!

Recover deleted site collection using powershell

  • Unfortunately, there is no user interface for restoring deleted site collections. Managing deleted site collections requires using PowerShell. SharePoint 2010 Service Pack 1 introduces 3 new PowerShell CmdLets for managing the Recycle Bin for site collections.

    • Get-SPDeletedSite
    • Restore-SPDeletedSite
    • Remove-SPDeletedSite

    The easiest way to get a list of all the deleted site collections is to just call Get-SPDeleteSite without any parameters. In the following example, for brevity, I have formatted the output as a table and filtered the columns displayed. In the second sample, I have added a wildcard filter to the command that can be used to easily filter sites based on relative paths.

    1178_5Once you have identified the site you want to restore, you call the Restore-SPDeletedSite. To restore one or more sites, it is easiest to just pipe the results from Get-SPDeletedSite. By default, the command will ask you to confirm the restore. To eliminate the confirmation, just add “Confirm:$true” to the end of the command.

    1178_6

    Ref: http://mssharepointtips.com/tip.asp?id=1178&page=3

     

Stringbuilder object returning result while using Append function

Problem

For appending content to stringbuilder object we use Append() as

$sb = New-Object -TypeName “System.Text.StringBuilder”;
 $sb.Append(“This is a demo”);
expected the result is
This is a demo
However the result is
                  Capacity                MaxCapacity                    Length
                  ——–                ———–                    ——
                        16                 2147483647                         11
This is a demo
Reason
Several of the methods on StringBuilder like Append IIRC, return the StringBuilder so you can call more StringBuilder methods. However the way PowerShell works is that it outputs all results (return values in the case of .NET method calls).
Solution
In this case, cast the result to [void] to ignore the return value e.g.:
[void]$sb.Append(“This is a demo”)

Sandbox solution to manage anonymous access on Office 365 / SharePoint 2013.

You can enable anonymous access to office 365 account using following sandbox solution:

http://anonymous365.codeplex.com/

Steps to configure a sharepoint list on my public facing sharepoint site that is accessible for anonymous users:

  • Download the anonymous365 sharepoint solution from http://anonymous365.codeplex.com
  • Go to the “Site Settings” of your public facing site using by example :http://brxyz/_layouts/settings.aspx
  • Go to the “Galleries” section and go to “Solutions“.
  • Click under the “Name” colume and in the ribbon interface under the “Solutions” tab choose “Upload Solution“.
  • Browse to the previously downloaded anonymous365 sharepoint solution : “Wsp365.Anonymous.wsp” and press “OK“.
  • Check the checkbox of the uploaded “Wsp365.Anonymous.wsp” and in the ribbon interface under the “Solutions” tab choose “Activate“.
  • The go to the “All Si​te Content” of your public facing site using by example: http://brxyz/_layouts/viewlsts.aspx
  • Press “Create“
  • Choose the list type you want, enter a name and press “Create“.
  • Then in the ribbon interface under “List Tools” and “List” press the button “Anonymous Access“
  • Choose what acce​ss you want to give anonymous users for this specific list and press “OK”example