DateKeys are essential for relative time measures. In “manage relationships” you tie the ‘DateKey'[Date] to a date field in each of your data sources. Giles Walker shared an excellent solution for a robust DateKey that includes measurements and calculations you’re sure to find useful. Here’s that same solution I’ve modified and expanded to be as useful as possible.
Maybe you’ve made a PowerApps customized form but want to switch back to the original SharePoint new item form. Here’s how:
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 (&) in document names. In this case, SharePoint evaluates apostrophes (‘) to ' and ampersands (&) to & As you can see here, most other punctuation evaluates perfectly well:
Note: This problem only occurs when using apostrophes and ampersands in document names, in document libraries. And we can fix the issue without needing to rename the files.
Document names cannot contain these punctuation marks: \ / . : * # “
Regular lists and document library fields aside from the Name field shouldn’t experience this issue. But if you’re using & or ‘ in your file names, and calling those file names in workflow, here’s how we can make it work:
Look at that workflow above – have you ever seen something so beautifully simple? I’m excited to share several solutions with you in this one post. This post should cover the following:
- Working with content types
- Creating a template for each content type capable of having merge fields
- Finding a way to merge list item info into a new document via workflow
- And if you’re super ambitious, expanding the workflow just a bit with an if/then statement to use different templates based on conditions in your list
But because this is a massive topic and could be tailored an infinite number of ways, I encourage you to comment or tweet me for additional guidance more specific to your scenario. So here we go!
Update 9/12/17: Video tutorial at bottom of post
Alternating list row colors can help your list go from zero to hero in just a few minutes. It’s another quick fix that makes your data easier on your viewers’ eyes and helps with user adoption, especially those coming from programs and platforms that had alternating row colors built-in.
So you’ve made a SharePoint calendar. In fact, you’ve even made some different views for it and then made those views into overlays. Hoorah!
But now, looking at the finished product, the unevenness of the overlay links leaves something to be desired. This post will show you how to take your overlays and, in just a few minutes, turn them into a more polished look as seen above.