Wow, we’ve been asking about it for a (long) while: https://powerapps.microsoft.com/en-us/blog/announcing-column-comparison-through-fetchxml-sdk-and-odata/ Do you want to do column comparison with Fetch? You can do it now – it’s only supported for a few conditions so far: Equal NotEqual GreaterThan GreaterEqual LessThan LessEqual And it’s not, yet, supported in the UI query building tools (Advanced Find).… Read More »
I was looking at this post by CRM Ninja, and it hit me that, even though that post had a different purpose, it had an interesting workaround for the “one relationship only” problem which happens when trying to add the same relationship more than once to the query. For example, on the screenshot below, I… Read More »
Not without some help, but, it seems, I’ve just uncovered a skeleton in my closet. Which turned out to be this old blog post I wrote back in September 2019: Now, I stand corrected TWICE in just one day (just for the reference: https://crmtipoftheday.com/1372/synchronous-power-automate-flow-on-create-update-of-a-record/). That’s a little unusual feeling, but, well, the truth has to… Read More »
Did you ever try to put a really big IFrame on the model-driven form? If you did, and totally irrespective of why you would do such a bizarre thing, you might have seen this message: Those 40 rows, whatever they mean in pixels, is the maximum you can get if you go with a regular… Read More »
Here is a really quick question before you continue reading. When looking at the image below, can you see what’s wrong there? Of course the answer is – it’s a Canvas App trying to pretend it’s a model-driven app: That’s a little experiment I wanted to try, and, quite honestly, as entertaining as it was,… Read More »
To start with, why do I even call it a battle? Isn’t it supposed to be a peaceful coexistence where each type of power apps can contribute where the other type is lacking in functionality? In theory, yes. In practice, it seems things may spin out of control in the extreme cases. Imagine there is… Read More »
Just got to play with the latest cool feature, which is using SQL Management Studio to connect to CDS environments. You’ll find the documentation here: https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/cds-sql-query If you have not seen what it looks like, here is an example: To set it up, you just need SSMS v18.4, and don’t forget to configure your environment… Read More »
I have certainly missed some news. Apparently, quick find in the unified interface now works as it has always been expected to work (but never did): It’s now using selected view columns And it’s now applying selected view filters If I were reading release wave 1 plan more carefully, I would have noticed the following… Read More »
I was troubleshooting missing dependencies earlier today, and, after some digging, uncovered a hidden solution in the environment. I could see that solution when looking at the layers: And I certainly could not see it in the list of solutions neither in the old interface, nor in the new one. Well, there is always a… Read More »
Social distancing has definitely took a toll on my blogging – it’s been a while since the last post. Although, I’ve actually learned quite a few things outside of PowerPlatform in the last month, so I could probably start blogging about a few other things now: How to teach math fractions How to build wooden… Read More »