The Baretta

What When you're building a PowerApp connected to a SharePoint List Form and you would like to capture the details of the person who is filling out the form. Why I understand that this is already captured via the 'Created By' SharePoint System field, but sometimes customers like to capture requestor name, phone, etc on the form itself rather than having to go to SharePoint to view it all. Assumptions: You've already created a PowerApp and added a 'Form' Control that uses a SharePoint List as a Data Source. Your SharePoint List contains a People Picker Field How To pull back details about users, add another Data Source: View  Tab > Data Sources > Add Data Source > Office 365 Users Click on the Card in the form that contains your People Picker Field Go To Advanced and click 'Unlock to change properties' so that you can select the field itself Click on the People Picker Field itself, then select the 'Default'...

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 ...