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. πππ
Category: 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
How to β Get the size of tables in Dataverse / Dynamics 365
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
Hope it helps..
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
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