Blog

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

Azure Integration, Business Applications, Common Data Service, Power Platform

Azure Storage integration for Power Apps portals

To answer the question Why? I say we run into some limitations with SharePoint integration. And now we are trying to explore other options. Let's get started! Enable Azure Storage This is a great blog post here: Want to leverage Azure storage for your documents in PowerApps/ Dynamics 365 portals instead of Notes? Check this… Continue reading Azure Storage integration for Power Apps portals

Dataverse, power automate

Power Automate with Dataverse: Saving API calls to Dataverse. Expand or Link-Entity?

Within Power Automate I am trying to make SINGLE(paginated) call to Dataverse to get the list of Work Orders with the particular status linked to Account but not directly but via extra layer. Also, I can retrieve extra lookup tables which are required by logic. All in a single call because making extra API calls… Continue reading Power Automate with Dataverse: Saving API calls to Dataverse. Expand or Link-Entity?

Dataverse, power automate

Power Automate with Dataverse: “Apply to each” current item/previous item

Recently I was working on the solution and in the middle of the development discovered that I desperately need to refer to the previous item in the loop. Let's say, I iterate through the list of items I received via List Rows (Dataverse). I check a condition in the next iteration and based on the… Continue reading Power Automate with Dataverse: “Apply to each” current item/previous item

Business Applications, dynamics 365, Dynamics 365 - new UI, PowerApps

How do I pass executionContext as a parameter into my Promise to fit in Promise.all()?

To be honest, this post should be a bit longer with more details but I like it this way. This is a sample below. It looks cool. And I building one of my own. But I need it to work with my onSave form validation. const promise1 = Promise.resolve(3); const promise2 = 42; const promise3… Continue reading How do I pass executionContext as a parameter into my Promise to fit in Promise.all()?

PowerApps

Where is my Tenant ID? (not Azure portal)

In the casual conversation with Microsoft I was asked about my customer Tenant ID. As a person who use to superpower and admin privileges I went straight to Azure portal: https://portal.azure.com/#blade/Microsoft_AAD_IAM/ActiveDirectoryMenuBlade/Overview Unfortunately, I don't have the same level of power in my customer organisation as I have in my own. I simple didn't have access… Continue reading Where is my Tenant ID? (not Azure portal)