The ask, update some JSON column formatting. Someone reworked a Microsoft sample snippet and added a clickable icon to their SharePoint Online document library, but the icon is visible for all library items. For their project, the icon needs to only be available for specific items, not all folders or file types. Figure 1 - … Continue reading Formulas: SharePoint Online | JSON Formatting – Conditional Column ‘Display’
SharePoint Library
SharePoint Online: JSON Column Formatting | Link to Power Apps
The ask, create a dynamic link from a SharePoint Online (SPO) document library, navigating end-users to a Power Apps canvas app. This app expects "deal_id" as a parameter, Param(), which would be the id of the library item. Is it possible? Yes. Is it complicated? No. SPO libraries, which inherit from lists, are relatively easy … Continue reading SharePoint Online: JSON Column Formatting | Link to Power Apps
SharePoint Online: Document Sets | Default Folders Only
Document sets are essentially metadata-enabled folders, ideal for standardizing and bundling documents in a predefined folder structure, allowing people to manage their related assets as a single entity. Imagine HR onboarding a bunch of new hires. On their first day, HR creates a record for each person, then shares the item with the respective new … Continue reading SharePoint Online: Document Sets | Default Folders Only
SharePoint Online: Understanding | Document Sets
Likely an oversimplification, but document sets are essentially collections of files and folders bundled together with shared metadata. A holdover from earlier versions of SharePoint Server, document sets aren't enabled by default in SharePoint Online [SPO], but can be enabled as a feature at the site collection level: Figure 1 - SharePoint Online site collection … Continue reading SharePoint Online: Understanding | Document Sets
Power Automate: Copy Emails + Attachments to SPO
Closing out this story, the Power Automate flow built to copy Outlook emails to [SharePoint Online] should have copied the email attachments as well. Though not every email has attachments. Tweak the flow and check for attachments, then copy when necessary... Reviewing a previous flow run, examine an export of the tempObj variable. Take note … Continue reading Power Automate: Copy Emails + Attachments to SPO
SharePoint: What If… Metadata?
Metadata is baked into SharePoint. Even so, many people use SharePoint just for document storage and never explore metadata. But without metadata, SharePoint isn't living up to its full potential. What is metadata? Why is metadata important? For simplicity, think of metadata as "document tagging"/ "document categorization". With the documents tagged, search gets leveled up. … Continue reading SharePoint: What If… Metadata?
Power Apps: Recreating… Twitter
At last, closing out the Power App recreation series. Kicking things off, the first app mocked up Instagram. Nothing fancy, but the app used two galleries populated from two Excel data sources. The second app roughly recreated Netflix and again, used two galleries and two Excel data sources. However, app #2 used the Filter() function … Continue reading Power Apps: Recreating… Twitter
console.log('Charles'); 