Category: 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…

  • 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…

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

    Originally posted on 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…

  • 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…

  • 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…