When automating processes in SharePoint with Power Automate, you might encounter situations where you need to retrieve specific files by their names. This is particularly useful in scenarios where file names are used to identify document types, project names, or specific documents required for a process. Power Automate provides a straightforward way to achieve this through the use of the FileLeafRef
property in the "Get files (properties only)" action.
Filtering SharePoint Files by Name in Power Automate
Filtering Files and Folders in SharePoint with Power Automate
When working with Power Automate and SharePoint, one common task is retrieving items from a document library. However, document libraries contain both files and folders, and often, you may need to work exclusively with files or folders. Understanding how to filter these items efficiently can streamline your flows and make your automation processes more effective.
Mastering SharePoint Internal Schemas: A Comprehensive Guide to Filtering Person or Group and Lookup Columns
Mastering SharePoint Internal Schemas: A Comprehensive Guide to Filtering Person or Group and Lookup Columns
Introduction
Navigating SharePoint's complexities can often be a daunting task, especially when dealing with intricate internal schemas like Person or Group and Lookup columns. These elements are pivotal in creating dynamic and functional SharePoint lists and libraries but can present challenges in understanding and applying their internal naming conventions, particularly when integrating with tools like Power Automate. This guide aims to demystify these complexities, providing a practical overview of SharePoint's internal schemas with a focus on filtering Person or Group and Lookup columns. We'll use a real-world example to illustrate these concepts:
[TIPS] Hide date format "12/31/2001" when date filed is unselected or blank in Canvas App
Issue:
In Power Apps (Canvas App), when use SharePoint as the data source, the date field always shows "12/31/2001" even this field is blank or not selected.
[TIPS] Power Apps SharePoint form setting date/time field to blank
Power Apps SharePoint form setting date/time field to blank
ISSUE: Can't clear a datetime field in SharePoint from PowerApps.