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 …
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 …
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 …
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 »
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 automation. Now, you want to upgrade to the next level and use Power Automate in a more holistic approach within your company, which leads you to the Microsoft Pricing page, …
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 Read More »
