When working with Power Automate and SharePoint lists we usually are in need of extracting specific rows of data from lists, to do so, we need to use the “Query filter” field available in the SharePoint “Get Items” action. OData queries are usually written in the following format: {InternalColumnName} operator {value} For example, if we […]
Ultimate guide to OData query filters for SharePoint in Power Automate Read More »
Unfortunately, Dataverse Business rules do not work on Power Pages sites, so if you need to dynamically show or hide controls based on another’s control value, you will need to add some custom JavaScript to your site. But don’t you worry! It’s much more simple than it sounds. For this use case we want to
Show or hide fields in a Power Pages form Read More »
We’ve previously talked about Power Automate pricing, so we thought it’s time to talk about Power Apps and its pricing structure. If you’re here, you’re most likely already using Power Apps and now you wonder: Do I get anything without additional charge by having a Microsoft 365? Which type of apps will require a license?
Power Apps Licensing (updated 2024) Read More »
Table of Contents Dataflows are an amazing tool to bring data from external systems into your Dataverse environment, and today we will show you how you can use them to bring data from your data entities in Dynamics F&O and push it to a Dataverse table. You can also read this post in our Linkedin page.
Use Dataflows to bring your Dynamics Finance & Operations data entities to Dataverse. Read More »
One of the most read articles on our Power GI website is on Power Automate licensing structure. But a lot has changed since we first wrote it, so we decided to write a new blog with the most recent updates. If you’re here, most likely you have already come across Power Automate either Cloud or Desktop
Power Automate licensing explained (Updated 2024) Read More »
If you have worked on a Power Platform project that needs connections to MySQL, then you might have noticed views are not listed when browsing the catalogue of a MySQL database. In this blog post we bring you a quick trick on how to successfully retrieve data from MySQL views from both Power Automate and
Use MySQL views from Power Automate and Power Apps Read More »
We usually talk about Power Platform here, but this time we bring you some awesome VBA piece of code that you use to split the content of an Excel worksheet into multiple files, based on N number of rows – created by our colleague Jeymi Membreño. Say goodbye to manual splitting and hello to automation
Excel VBA macro to split sheet contents into multiple files Read More »
A connection reference, a key component in a solution, contains vital information about credentials used to connect to a Power Platform connector. During the import of a managed solution into an environment, users face a choice: selecting an existing connection or creating a new one. It’s crucial to note that, once a managed solution is
Update connection references in a Managed solution – Power Platform Read More »
This blog will show step by step how to create an Azure Function App to upload files to SharePoint using C#. This code will receive a public URL that contains a file to download, and we will upload this file to SharePoint, using the Graph API – and by the way, this function was created
Azure Function App: upload files to SharePoint from a public URL Read More »
When we are using Power Automate Desktop to download files from the web, it’s a very common use case to want to upload them to a SharePoint site. There are two ways to achieve this, depending on if you have a Power Automate Premium account or if you don’t. Content Option 1. You have a
How to upload files to SharePoint from Power Automate Desktop? Read More »
