What is Copilot? Microsoft 365 Copilot is an Artificial Intelligence assistant that can be used for Microsoft 365 apps and services, the Power Platform included! Creating a new Power Apps with Copilot Visit the Power Apps portal: make.powerapps.com. You will notice this section in the home screen. Just start typing a simple description of the […]
Use Copilot and AI to create Power Apps apps Read More »
You have an MS Excel template that needs to be filled out every time a new record in SharePoint is created: this means when a new item is added in SharePoint, a copy of the template needs to be created and our automation has to insert rows into it. In our example, we have a
Write to dynamic Excel files using Power Automate Read More »
Our use case: A word file needs to be generated everytime a new application is submitted – with some fields that come from the application form such applicant’s first name and last name. Someone reviews the request, performs manual updates to the file and sends it for approval. When the file is submitted for approval,
Fill out dynamic MS Word templates with Power Automate Read More »
We have the following table with Request ID, date time value on when it was created and when it was resolved, and we need to calculate the hours it takes for each request to be completed. Our team works from 8 AM to 5 PM, Monday to Friday. First, make sure you create a calendar
Calculate Business / Working Hours using DAX Read More »
Table of Contents Sometime ago, we wrote about downloading PDF files from the web and overcoming Power Automate’s limitations when doing do. Since then, lots have happened and evolved within the tool, and several features have been added. The main change is that Power Automate used to have 2 recorders, one for web actions and
Everything about downloading files from the web using Power Automate Read More »
When you are using a combobox to filter a gallery based on the selection, you can check if the selection is blank or not, and depending on that, show only the records that match the combobox selection or show all records. For below scenario, we want to filter the Category of each record based on
Handle empty combobox when filtering Galleries in Power Apps Read More »
Updated licensing structure Please note a lot has changed since this blog from 2021 was created, make sure to read our most recent blog on this topic Read Here If you have an Office 365 subscription, you may have come across Power Automate, or you may already be using it for email or SharePoint
Power Automate Licensing Explained Read More »
We work with PDF files in day-to-day tasks, and we are in constant need of reading or processing the data in those PDFs (Bank Statements, Invoices, Exported data available in PDF format only, etc). We usually think of paid software or OCR systems to help us on this task, but did you know that both
Reading PDF Data from Excel or Power BI with Power Query Read More »
Power Automate has great functionality to manage Approval workflows. With a couple of steps, you can get approval requests triggered to both Teams and Outlook, but a lot of companies are looking to reduce the number of emails received and sent, so they want to use just Teams instead. In this post we show you
Use Power Automate Approvals with Teams notifications | no emails | adaptive cards Read More »
You just sent over 500 marketing emails to your distribution list, and you are now getting lots of “Undeliverable” emails back, then you realize that you have several emails stuck in the outbox – for some reason they were not sent. Sounds like you need a list of what was sent, what wasn’t, and which
Export Emails & Calendar Events to MS Excel Read More »
