“The Power Automate flow works if I use a date formatted SharePoint column, but I need a reminder based on a calculated date from another date column.” “The field ‘CalculatedDate’ of type ‘Calculated’ cannot be used in the query filter expression.” When you calculate a date or a number of days in SharePoint, you might not want to end there. Sure, it’s nice to display the date/number of… READ MORE
I know SharePoint Groups are not fashion any more, and a lot of people prefer using Sharing links to grant access to specific people, but I still find the SharePoint Groups very useful to centralize access to multiple SharePoint artefacts. I thought this would be quite simple using the SharePoint HTTP Request action but, something… READ MORE
Introduction With the introduction of SharePoint V2 REST API for Managed Metadata services, it has become very easy to create a term in term store using REST API. But what if we would like to automate things? In such cases we can use the help of Power Automate. In the automation, we would create a simple… READ MORE
If you are using Graph API in your Flows, you may want to safeguard client secret as it will be shown in plain text when you store the client secret value in a variable, its value will show up in the Flow history. This blog assumes that you have already created Graph API, app registration… 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
“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
In check device type of Power Apps post I would like to show alternative way to see if User is using browser or mobile Power Apps client. Content: Power Apps Signals approach Power Automate Headers approach x-ms-user-agent property Accessing data Example: Not to download PDF file Update of Flow Update of Power Apps Summary Power… READ MORE
In this blog post I will show how to use Power Automate to create an attribute-based ID in Microsoft Lists. Attribute-based translates to business readable with formatting. This pattern is based on work I did at my previous employer where the List was being used for data imports into a legacy application that required a:… READ MORE
If until now one of the flows that I have helped to configure the most are those that are launched manually from a SharePoint element , Microsoft has surprised me again and without a doubt the new trigger for Teams will give a lot to talk about and will be the protagonist in many business solutions . Just a month… READ MORE
