The Baretta

Today we will be learning how to create a excel report connected to a SharePoint library using Power Query.  I will also address all issues found along the way. The reason we are connecting to our library via Power Query instead of via the 'Export to Excel' option is because our library contains InfoPath forms that have repeating table data in the columns that we need to report on. Power Query   Is a free excel add-in available from Microsoft for both Excel 2010 Professional Plus & Excel 2013.  It is used when you need a way to transform data that isn't quite in the format you need. Step 1: Connecting to your SharePoint Library via Power Query. Open up Excel.  Click Power Query Tab > From Other Sources > From SharePoint List > Insert SharePoint Site URL Here's our first issue.  Only Lists are appearing in the Navigator.  Not to worry, Right-Click any of the Lists showing and click Edit to open up the Query Editor.   You should ...

Came across an issue today with an InfoPath form I am working on. In the form there is a Repeating Table that contains within it both String and Boolean Fields. In order to make the form prettier we have created custom buttons to add a row to the Repeating Table.  These button use an XMLWriter to add a new row. For any new fields (String or Boolean) the writer does the following to create a blank Field: writer.WriteElementString("fieldname", myNamespace, ""); The problem I had was that if you created Boolean fields like the line above, and then tried to Submit the form to SharePoint, you receive a validation error "Some rules were not applied.  InfoPath cannot submit the form" Turns out the Boolean Fields were failing to validate with the empty string value.   This was solved by putting in a value that isn't used in the form for the Boolean Field: writer.WriteElementString("fieldname", myNamespace, " 0 ...