Category: Common Data Service

  • Power Apps Portal: deactivating records from a portal via Web API

    All the amazing docs, which help you to start are available here: https://docs.microsoft.com/en-us/powerapps/maker/portals/web-api-perform-operations#update-and-delete-entities-using-the-web-api https://docs.microsoft.com/en-us/powerapps/maker/portals/web-api-overview#web-api-operations I was testing the scenario where we had to workaround with the plugin: prior portal Web API times 🙂 it wasn’t possible to deactivate a record from a portal with a status different from the default one. Now it’s super easy!…

  • Power Apps portal Web API: (ERROR)An undeclared property … which only has property annotations in the payload but no property value was found in the payload…

    UPDATED POST HERE: https://wordpress.com/post/msolenacrm.blog/2147 Looking at Web API for portals this weekend. For the scenarios we currently workaround, with the API it’s all easy. There is a very documentation available which will help you to start: https://docs.microsoft.com/en-us/powerapps/maker/portals/web-api-perform-operations and here: https://docs.microsoft.com/en-us/powerapps/maker/portals/web-api-overview#web-api-operations When I was trying to bind a related entity on create I was getting the…

  • Xrm.WebApi. “The query parameter $select is not supported” error.

    Don’t be like me! This is the JavaScript: var uriClientLegacy = “?$select = cca_legacyservicefee, defaultpricelevelid & $filter=accountid eq ” + clientLookupId; Xrm.WebApi.retrieveMultipleRecords(“account”, uriClientLegacy).then( function success(result) { … }, function (error) { console.log(error.message); // handle error conditions alert(error.message); }); And this is the execution result: {“error”:{“code”:”0x0″,”message”:”The query parameter $select is not supported”,”innererror”:{“message”:”The query parameter $select is…

  • Power Automate: sum(field1, field2, field3, field4) is greater than 0.Easy?

    The requirement is to summarize 4 number field values to determine if the total is greater than 0. What could possibly go wrong? You think it should be somewhere in the Expression under Math functions. Think again. The add only allows to summarise 2(!?) numbers. Not 3, not 4. It let me to add extra…

  • Power Automate: PARSE JSON action with value or null

    Power automate is endless fun! Today we are going to explore a very “simple” issue which are 2 issues actually: how to define “allow null” in a schema to avoid annoying errors how to get away with the 1. without the painful consequences Let’s start from the beginning! PARSE JSON is a very useful action…