Power Platform Guide

By default, SharePoint Get Items action only returns 100 items which matches your Filter Query.  You must always try to use ODATA filter query to reduce the number of rows that are being returned to you. This will make your cloud Flows much for efficient. If you have a large SharePoint List and your use-case requires, getting more than 100 items, then you will need to make a small setting change to the Get Items action  in your Flow. You will have to do this change each time you add a Get Items action requiring more than 100 items. 1 - If your requirement is upto 5000 records In this scenario, you can change the Top count property to 5000. 2 - If your requirement is upto 100,000 records Under this scenario, click the 3-dots ellipses next to the Get Items action and turn on the pagination settings with Threshold equal to or less than 100,000 depending on your use-case. Note that your license type may restrict the maximum number your can use in the Threshold settings. All licens...

You have a SharePoint Document Library where your users are uploading documents. You then use that information to perform other automated tasks such as closing tasks, getting approvals, sending notifications etc.  However you don't want your users to upload a particular file-type, for example, you don't want people to upload Excel Macros into the SharePoint Document Library. Every time someone uploads an Excel Macro file, you want to email them about your policy. To construct this in Power Automate, we will use endsWith() expression. We will create a Condition block and check if       endsWith(triggerOutputs()?['headers/x-ms-file-id'],'.xlsm') is true Under the "Yes" branch of this Flow, we can email the person who has uploaded the Excel Macro file about the policy, or take any other step as per our business use-case.