Tuesday, June 29, 2021

Bug in Teams Dataverse/PowerApps connector

Fortunately my level of trust with anything new on the Power Platform is near zero.  Everything must be tested before I will rely upon the most basic features available.  This caution paid off today in that I only wasted about 15 minutes before figuring out the problem.

I was getting the error: The function 'Patch' has some invalid arguments. The specified column X does not exist.  The column with the most similar name is X.

The issue?  You cannot (currently) Patch() a record from a Collection to Teams Dataverse (but you can to SharePoint, SQL, etc...)

Oddly enough, both work fine connecting to the standard Dataverse (non-Teams).

NOTE:  I have a "fix" from MS and will detail below

Friday, June 18, 2021

What is Power FX (or PowerFX or PowerFlex or "new name they come up with next quarter")?

Microsoft announced at Ignite 2021 that they are working to unify the languages used across the Power Platform.  This is an attempt to lower the learning curve on some aspects of their overall platform as well as to update some of the (very) dated languages that exist within the Microsoft ecosystem (I'm looking at you Excel).  They've also just (as of June 17th 2021) integrated their Power Platform CLI w/ the ability to unpack/merge source code easier.