Nate Chamberlain

16 Flips | 1 Magazine | 2 Likes | @NateChamber2017 | Keep up with Nate Chamberlain on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “Nate Chamberlain”

Generate and send reports, files or lists regularly with Microsoft Flow’s “recurrence” trigger

Automatically create and send reports, files and lists on a regular schedule using Microsoft Flow’s recurrence trigger. Whether hourly, daily, weekly …

Microsoft SharePoint

How to change Microsoft Flow’s default limit of 100 items for “Get Items” and “Get Rows” actions

The first time I created a flow for a list with over 100 items, I noticed an “Apply to Each” block stopping at 100 items. It’s a simple fix:<p>Click the …

Microsoft SharePoint

How to make a Microsoft Flow mobile button to be emailed Microsoft Forms or SharePoint data as Excel link or attachment

Microsoft Flow mobile buttons are magical. One touch on your mobile device, and gears start turning to retrieve and deliver the data you need when …

Collab365 24-hr Global Conference Recap

The 24-hr Collab365 Global Conference has come to an end. This event is so well done (kudos to Mark Jones & co.), and was the second year I have been …

Microsoft SharePoint

Convert Time Zones in Power BI using DAX

In the Data tab of Power BI, create a new column in your data source (<b>not a new measure)</b><p>Enter the following equation, replacing red text with your …

Power BI

Convert SharePoint documents to PDF automatically using Microsoft Flow

Trigger: SharePoint – When a file is created or modified (properties only)<p>Condition: Publish = true <i><br>Note: You’ll need to edit this condition in</i> …

Software

Dealing with ' and & in SharePoint Designer document library workflows

If you’re using a document Name field in a workflow but it’s not working as expected, it could be because there are apostrophes (‘) or ampersands (&) …

Microsoft SharePoint

OneDrive and SharePoint sync issue: “You now have two copies of a file; we couldn’t merge the changes in [filename]” appended with computer name

If you’ve seen a similar notification, I empathize with your pain. I don’t know that there is one solution to this problem, either, so I’m going to …

Solution: Using a Yes/No checkbox in a Microsoft Flow condition statement

It’s not uncommon to want to use yes/no checkboxes when building Microsoft Flow conditions. <i>[Field] is equal to “Yes”</i> or <i>[Field] is equal to true</i> won’t …

Show more or all views in a classic view SharePoint list

By default, you’ll see 3 views in a SharePoint list. Using simple javascript, we can make sure our users see that fourth or fifth view as well, …

Speaking at SharePoint Saturday Kansas City on September 16

I hope to see some of you this Saturday at SPS Kansas City, where I’ll be sharing an overview and demos on using workflows to improve business …

Change SharePoint “Save” button to “Submit” in new item forms

Go to your list’s newform.aspx page by changing “Allitems” or your default view name with “newform” …

Sending emails via SharePoint Designer workflow to external recipients using Gmail, Yahoo, Hotmail, etc. addresses

SharePoint Designer 2013 workflows verify email recipients as valid SharePoint users. If they’re not on your site they likely won’t be able to …

SharePoint Calendar Cleanup: Use one workflow to remove Outlook “Copy:” prefixes, standardize location names and delete canceled events

We’ve all been there. One location on a shared calendar will be referred to by multiple people as 20 different things. Johnson Building Room 214 can …

Keep custom headers, footers, CSS, etc. from loading in SharePoint modal dialogs

Open your master page for editing (or wherever you’re placing your custom script).<p>Find your custom divs (in my example, footer-fixed)<p>Add</i> …