Table of Contents It’s possible to capture signatures in a Power Pages portal by making some adjustments to the form metadata in the Power Pages Management portal, in this blog, we will show you step-by-step how you can set up your Dataverse table and field to allow your users to input their signature using the […]
Use Pen control in Power Pages form or Model-driven apps Read More »
Table of Contents This blog will show how to work with Epoch format in both seconds and milliseconds in Power Query. You can use the formulas shown in both Excel and Power BI. From DateTime format to Epoch We will start with a regular date and we want to convert it to Epoch format: Convert
Epoch dates in Power Query | Excel | Power BI Read More »
Table of Contents Let’s suppose we receive inventory files from our provider, and we need to upload these stock counts in our ERP system every time we get these files. The file format our ERP system requires is a CSV document but the file from the provider is in XLSX format. In this blog we
Convert Excel file to CSV format with Power Automate (xlsx to csv) Read More »
We want to analyze how invoicing works in our company, and we would like to find out which service category is the one we’re selling the most and which we could improve. So, we pull data related to all invoices we’ve sent to clients, and we find the following table: As you notice, invoice line
Lookup by keyword in DAX | Contains Logic | Power BI and Power Pivot Read More »
Table of Contents When we create approval requests with the out-of-the-box action in Power Automate, our flow will usually wait for the approval to happen for next steps to keep running, and this can be an issue if something happens with an approver and we can’t get them to complete the request. So, sometimes it
Table of Contents When we save data in SharePoint or Dataverse from Power Apps, datetimes are stored in the universal time zone (UTC) and whenever we show date time columns in the apps, Power Apps will always recognize the user’s setting and will show date time based on this. There are some scenarios in which
Always show EST time zone in Power Apps Read More »
Table of Contents We were recently working on an automation that syncs on demand 2 different systems, end users use a button in a Power Apps app to execute this synchronization any time of the day, this automation takes around 15 minutes to run. It may happen that two users in two different departments request
How to cancel a flow run if there is another execution running? Read More »
Either because we created too many rows when we were testing or because requests are no longer applicable, the approvals module in Power Automate can end up with plenty of requests that do not require action: In this blog we will show you how we can use Power Automate and Dataverse to cancel old requests.
Cancel old approval requests sent from Power Automate | Dataverse approvals Read More »
A couple of weeks back, we posted this article on how to extract the content of a .eml file using Power Automate, but we recently discovered that there are some instances where the approach we explain in the previous blog will not work. The first approach we presented relies on the Power Automate Outlook trigger to
How to recognize .eml files with Power Automate? | Hidden attachments Read More »
Power Automate has some cool out-of-the-box features to read data from Excel files. But if you want to read this data using these actions, the data needs to be formatted as an actual table in the file and not a flat range – but don’t you worry, Office Scripts got you covered! With Office scripts
