Business Applications, Dataflow, Dataverse, Uncategorized

Dataflows for PowerApps: loading data from CSV file without copying it to OneDrive in advance. 💖😎👍

I would like to share my recent experience with loading a CSV file via Dataflow to Dataverse with you. Today, I downloaded the list of leads from the conference we sponsored last week. There is no better way to load it to my sales app on Dataverse - it's a Dataflow way! At least for… Continue reading Dataflows for PowerApps: loading data from CSV file without copying it to OneDrive in advance. 💖😎👍

Uncategorized

Power App Portal Web API – fighting lookups

We will start with the 100% helpful Microsoft docs articles: https://docs.microsoft.com/en-us/powerapps/maker/portals/web-api-overview https://docs.microsoft.com/en-us/powerapps/maker/portals/web-api-perform-operations I haven't had any issues with simple type fields but I stuck with lookups. Remembering my first time exploring the portal Web API, I didn't run into this issue. Or maybe it worked slightly differently during that times. There are some articles in… Continue reading Power App Portal Web API – fighting lookups

Uncategorized

How to – Get the size of tables in Dataverse / Dynamics 365

Nishant Rana's Weblog

Using the Capacity page in the Power Platform Admin Center we can extract the details of size occupied by table (in MB) within a particular environment.

Login to the admin portal and navigate to Capacity

https://admin.powerplatform.microsoft.com/resources/capacity

Select the Dataverse tab and click on Details or in case of trial click on the Trial tab

Here we have selected the details (graph) option for one of the environments.

Select Download all tables option for the Top database capacity use, by table chart


We can see the details within the extracted CSV file.

Get all the details here

https://docs.microsoft.com/en-us/power-platform/admin/capacity-storage#environment-storage-capacity-details

Hope it helps..

View original post

Azure Development, Custom Connectors, Dataverse, Power Automate, Uncategorized

Azure Functions in Power Platform multiple environments

Working with real customer’s deployment requires managing multiple environments – at least Test and Production or additionally a Dev environment. One of the common patterns we use in the solutions is to use Azure Functions as an effective, serverless extension of the point-and-click Power Automate flows. This pattern utilises a Custom Connector created to embed the function call and parameters into… Continue reading Azure Functions in Power Platform multiple environments

dataflow, Dataflow, Dataverse, PowerApps, Uncategorized

Dataflows for Power Apps: transform fixed-width text files

What is a fixed width text file? Data in a fixed-width text file is arranged in rows and columns, with one entry per row. Each column has a fixed width, specified in characters, which determines the maximum amount of data it can contain. No delimiters are used to separate the fields in the file. Could we load data from… Continue reading Dataflows for Power Apps: transform fixed-width text files