Searching Sensitivity Labels in SharePoint Sensitivity labels are a powerful tool for protecting documents, offering features like watermarks, encryption, and access control at the file level. However, the default Sensitivity column in SharePoint has limitations—it cannot be filtered, indexed, or bulk updated. This blog post explores ways to search for sensitivity label values in SharePoint and highlights some challenges and potential solutions. Challenges with Sensitivity Labels in SharePoint The crawled managed property InformationProtectionLabelId refers to the sensitivity label’s GUID/ID, which is not user-friendly for end users to easily search.

Read Rows in Excel Using Power Automate with ‘Create Table’ Action When working with Excel files that need to be imported into a SharePoint list, you may encounter scenarios where the data is not already in table format. This can be challenging, especially if the Excel files are automatically generated by an external system and cannot be manually updated. This blog post demonstrates how to dynamically convert raw data into a table using the Create Table action in Power Automate and subsequently read rows using the List rows present in a table action.

Power Automate: Retrieve SharePoint Library Internal Name When working with Power Automate, you may encounter scenarios where you need the internal name of a SharePoint library. For example, when creating a file in a library using Power Automate, the internal name is often required. Instead of manually adding the internal name as an environment variable, you can dynamically retrieve it using the Send an HTTP Request to SharePoint action. This blog post demonstrates how to retrieve the internal name of a SharePoint library using its ID or display name.