Author: Olena Grischenko (she/her)

  • 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. I am making two Web API calls to query data…

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

  • Dynamics 365 Sales Pro Trial Setup

    Go to: https://trials.dynamics.com/ Let’s create your Sales Pro trial in these easy steps (below). Scroll down to the highlighted option. Go to Admin center. Click on New. Select Trial (subscription-based) as a Type. You need to select a database and app in the same step. If you fail this multiselect turns into a dropdown as…

  • Getting data from a function in an on-prem SQL server via Gateway in Power Automate

    Originally posted on CloudMinded: “We are screwed!” me at the moment of technology induced panic That was the feeling when I saw the below error messages. The client’s setup is an on-prem SQL server exposed to the cloud via an on-prem Gateway. It works perfectly fine for exiting Dataflow integration, but this time we needed…

  • Dataflows for Power Apps: calling a table-valued  SQL function with Power Query

    It’s very easy to query SQL table-valued function to retrieve the result with Dataflows. This is how we do this. Let’s connect to a database. It will work via gateway as well. Select your function. Pass the parameter if required. Now you can use this table to merge with other tables or map and load…