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.

PnP PowerShell: Enabling and Configuring Document ID in SharePoint The Document ID feature in SharePoint is a powerful tool that assigns a unique ID to files, making it easier to reference and track documents. The script within the post activates and configures the Document ID feature using PnP PowerShell. Additionally, it covers the Set-PnPSiteDocumentIdPrefix cmdlet, which simplifies the process of setting a custom prefix for Document IDs. Why Use Document IDs?