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

PURPOSE Ever wondered what sort of SQL data connections are possible in SharePoint Online? Ever wondered of the limitations when trying this type of setup? If so, read on...  This tutorial will go over all the steps to setup everything from scratch.  Every step is important, you miss one, it won't work. WHAT YOU NEED SharePoint Online Plan 2 (you cannot achieve this with the basic version of SharePoint online as you require access to the Admin panel to setup Secure Store access permissions and BCS permissions. A windows azure account (which you can get a free 30 day trial as long as you're willing to provide your credit card. SharePoint Designer 2013 installed locally (required to create the final connection to the azure DB. Please note, you'll make this a hell of a lot easier if all these accounts are setup using the same office logon.  Otherwise you'll be logging in and out like a madman. IMPLEMENTATION Step 1 - Create SQL Database:   ...