Power Automate can add user accounts to SharePoint Online list items. If the person column accepts a single account, then the assignee claims are passed as a string. But for multiple accounts, the assignee claims are passed as an array. Illustrating this, loop through a list of approvers, then add them all to a list … Continue reading Power Automate: Populate SPO User Claims (multiple claims)
SPOUsers
Power BI: SPOList – Records v. Tables
Power BI Desktop can connect to a variety of data sources, including [SharePoint Online] lists. The text, date, and numerical columns will map directly, but a Person column will become a Record... E.g., list column Approver is a Person. So, what are Records? These are indexed data structures. Similar to hash tables, tuples, and structs, … Continue reading Power BI: SPOList – Records v. Tables
Power Automate: Populate SPO User Claims
Power Automate is the workflow engine of the Power Platform. Essentially, "Flows" access data via connectors, then perform tasks using actions. Included is a connector for [SharePoint Online] and a few dozen actions. Some actions to highlight: Get itemsUpdate item SCENARIO Remote workers are submitting travel requests and corporate has delegated an approver per state. … Continue reading Power Automate: Populate SPO User Claims
SharePoint Online: External Sharing Audit (Option. II)
I recently wrote about external sharing in SPO. If you externally share content, then you may need to audit external accounts in your tenant. Note: Your tenant must allow external sharing. The Microsoft 365 Admin Center is your first resource to audit and report these external accounts. Secondly, you can use PowerShell to audit specified … Continue reading SharePoint Online: External Sharing Audit (Option. II)
console.log('Charles'); 