Note: To watch this webinar you must login to your ESPC Community Account by clicking the blue banner above the video. If you do not have an account, you can sign up here. Canvas Apps used to be tricky to manage where multiple people were working on the same project, especially when you are managing… READ MORE
In this article, I will describe how to create an Excel file dynamically with Power Automate and fill it with data from the Common Data Service. Creating those dynamically can be a bit tricky. Therefore, I will provide step by step description of how to do that. Scenario Let’s assume AB Company is using Dynamics… READ MORE
Most dataflows needs to have scheduled refresh setup so that the data will be up to date ready for the reports connecting to it. This post walks through the basic steps to set up the refresh. Dataflow Series This post is part of a series on dataflows. Create a dataflow Set up dataflow refresh Endorsement… READ MORE
Note: To watch this webinar you must login to your ESPC Community Account by clicking the blue banner above the video. If you do not have an account, you can sign up here. Have you built a Power App but find the look and feel leaves a lot to be desired? Then this is the… READ MORE
Have you ever wondered what the Skip Token parameter in the List Records action of Common Data Service (current environment) connector is for? In this post, I will explain how you can retrieve any number of rows, even more than 100,000 rows, by handling paging manually with the Skip Token parameter. By default, the List Records action in Power Automate can retrieve up to 5,000… READ MORE
This is going to be a short post. I want to share with you my approach for overcoming the threshold called data row limit, that prevents function “Collect” to get more than the set number of items. The data source in my case is SharePoint. I was inspired by @mrdang‘s answer to a community question, where he advised… READ MORE
“How can I display number of days between today’s date and another date in a SharePoint column without Power Automate daily updates?” Calculating a number of days between a date and today’s date is not simple in SharePoint. You probably use calculated column for that, but calculated column can’t work with today’s date directly. It… READ MORE
Power Automate is used to automatize actions, it therefore needs to connect to services. Most of them can be accessed using the default connectors without providing any secret or password, but sometimes, you need to operate the authentication yourself. The most common example would be calling Microsoft GraphAPI using the HTTP connector. In this case… READ MORE
I have created two new PowerShell functions for Granting or Revoking permission on items in the Power BI Report Catalog. These two will be the probably be the last two functions I create for Power BI Report Server for a little while. I’ll be working on SSAS cmdlets for the next week or two. RECAP… READ MORE
In SharePoint Online, whenever you create a library and turn on “Require check-out” before editing documents option or not, users are able to open files for collaboration in browsers or in their local Office clients. When they do that, the file is getting locked from access that could lead to its metadata changes. If you… READ MORE
