All posts in Office365

Building a Modern SharePoint Solution: Part 4 – Setting a SharePoint People Picker Field Programmatically in PowerApps

Continuing my series on building a modern SharePoint solution using PowerApps and Flow I want to show how to go about setting a SharePoint people picker field programmatically in PowerApps.  This goes back to one of the requirements listed for my solution in part 1 of this series: “Requestor’s manager should be auto-populated as an approver”.  What’s nice about this is the manager field is filled in already by the company’s administration system.  It exists in Azure AD and thus within Office 365, which just so happens to have a connector that easily allows us to build with it.  I am getting ahead of myself though.  Let’s dig in and learn how to do this.

Posts in this series:

Read more

Building a Modern SharePoint Solution: Part 3 – Customizations All List Form PowerApps Should Have

In this third post in my series on modern SharePoint solutions, I will cover customizing PowerApp forms to meet the requirements of the business.  We’ll first start off with some basic customizations that need to be done for most form integrations.  When I started to write this post I initially had planned to discuss the modifications you should make for all and then move on to the custom modifications for the solution requirements.  The “default mods” quickly filled up this post, so I have moved the custom mods to the next one.

Posts in this series:

Read more

Building a Modern SharePoint Solution: Part 5 – Cascading Drop-down Lists and People Picker in PowerApps

This is going to be the last PowerApp based post in this series.  After this, I will be moving on to completing the solution with Microsoft Flow.  In this post, I will show you how to create cascading drop-down lists in PowerApps.  This corresponds to the requirement in my first post: “Ability to select from a list of approvers based on the project or event.”  This was something that could be done in InfoPath, but it was a LOT of steps.  In PowerApps, cascading drop-downs are actually pretty straightforward once you get the hang of it.  I, however, decided to do the hardest type of cascading drop-down there is with regards to SharePoint. Building a drop-down around a regular field is nice and easy; cascading drop-downs to select a person\group value is much more difficult.

Posts in this series:

 

Read more

SharePoint Business Connectivity Services in SharePoint Online

I have always been a strong supporter of the SharePoint Business Connectivity feature.  I find that in many cases it allows for easy access to data you would normally have to develop custom solutions for or even pay large amounts of money in licencing for (SAP, PeopleSoft, etc).  BCS brings the ability to present data located in other systems into SharePoint.  A tool that many understand and use daily.  In this presentation I discuss using Business Connectivity Services within SharePoint Online as opposed to on premises.  You can find the slide deck here.  Thanks for attending my session on this topic.

 

Thanks for reading!!

Microsoft Flow – Updating a OneNote Book from Outlook

I continually get frustrated because there are so many great blogs and tidbits of information out there that I want to keep up on, but there isn’t enough hours in the day. On social media I often see great blogs posted by colleagues and friends, or in my day to day while looking for solutions, I will come across other blogs on my own. The problem is that during the day I simply don’t have enough time to read all of them. So I simply leave my tabs open to come back later during lunch or a break. Except that never seems to happen as something always comes up. I usually have plenty of time to read them in the evening once everyone is settled down at home, but I always forget what I was looking at. I have tried emailing them home, but they get lost within all the other emails I received. I set rules, but even if I come back to them, I like to take notes and emails aren’t the best place to do that. So after reading Tracy Van Der Schyff’s blog on moving notes to Planner and Teams I had a thought. What about going the other way?

Read more