Table of Contents We have a multistep form in our portal and one of those steps require to add one or multiple lines related to the main record – in our case, a list of contacts: We have a subgrid in one of our steps and we need to validate that at least one row […]
Validate at least one row has been created in grid – Power Pages – Dataverse Read More »
Table of Contents We have two tables in our data model, Waybill Header and Waybill Item Detail, these two tables are related by “Waybill Header ID”. Table relationships are usually indicated in Dataverse through Lookup Columns, so for this scenario we would need to add a lookup in table Waybill Item Detail against Waybill Header
Dataverse, Lookup columns and Power Automate | Filter data | Add and Edit rows Read More »
Table of Contents We can use Power Query to pull records from APIs where our data resides, but most of the time each API we connect to will work in different ways: Some APIs might bring all records on the same page Some APIs will limit the number of records you can retrieve Some APIs
Power Query pagination for APIs | Excel | Power BI Read More »
Table of Contents When working with Canvas Apps in Power Apps, Dataverse and file columns, it’s very common to want to have a “download” button that lets the user save a copy of the file in their local computer. This can be achieved in a way by using Dataverse API with the following endpoint: {environment-url}/api/data/v9.0/table_logical_name({record-id})/column_logical_name/$value
Table of Contents When creating a Power Pages site, if your form has a lookup column it will look a bit odd in the website for end users. It’s a very common scenario to prefer to display these types of columns as dropdowns instead. In this blog we will show you how to update the
Show Lookup Column as Dropdown | Power Pages | Dataverse | Lookup field Read More »
Table of Contents When working with Canvas Apps, sometimes we need some buttons to have some actions in common or to even do the very same steps when they are clicked. Like the example below, in which the “X” icon, the cancel button or clicking on the left area of the right panel should do
Quite recently we were working with the Accounts Payable team to automatically grab invoices received from suppliers and save them in a SharePoint site, we were using the regular “For each attachment”, “Attachment content” and then “Create file” actions in Power Automate for most vendors, until we found one vendor who did not attached their
Get content of a file attached in an email’s .eml attachment (nested attachments) Read More »
Business Process flows (BPF) in Power Platform are an amazing tool to guide end-users on the stages they should follow to complete a process, but sometimes it may become difficult to track which records in Dataverse are in which stage of the process and see all these records in a single view, for example. To
Update column value based on Business process flow stage Read More »
Sending approval requests is one of the most common use cases for which Power Automate is used for. After all, 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
Create long-running approval requests in Power Automate (override 28-days timeout) Read More »
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 »
