Graciela Martinez

Create long-running approval requests in Power Automate (override 28-days timeout)

Sending approval requests is one of the most common use cases for which Power Automate is used for, but the out-of-the-box connector for approvals has a limitation: if the approval request is not approved or rejected within 28 days, the action will time out and this will cause your flow to fail. In this post, …

Create long-running approval requests in Power Automate (override 28-days timeout) Read More »

Date pickers in Power Automate Desktop

Date pickers can behave differently from page to page, and populating this control type from Power Automate Desktop can get tricky. Did you know most date pickers also have an text input control that is easier to use compared to year/month/day selectors? – We gathered 3 examples from different web pages and we show you how to automate them …

Date pickers in Power Automate Desktop Read More »

Use Copilot and AI to create Power Apps apps

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 »

Write to dynamic Excel files using Power Automate

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 »

Fill out dynamic MS Word templates with Power Automate

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 »

Everything about downloading files from the web using Power Automate

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 »

Handle empty combobox when filtering Galleries in Power Apps

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 »

Reading PDF Data from Excel or Power BI with Power Query

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 »