Skip to main content

Power Automate: SharePoint Copy file action fails on file names with a plus (+) sign

Retrieve Object Type Codes via WebAPI Url

To quickly retrieve the object type codes you can add the following URL part to your CRM instance URL:

/api/data/v8.2/EntityDefinitions?$select=LogicalName,ObjectTypeCode&$filter=ObjectTypeCode%20gt%209999

The output looks like this:

{
  "@odata.context":"https://orgname.crm4.dynamics.com/api/data/v8.2/$metadata#EntityDefinitions(LogicalName,ObjectTypeCode)","value":[
    {
      "LogicalName":"msdyn_quotebookingproduct","ObjectTypeCode":10076,"MetadataId":"eabdb23d-67d9-4c20-b72e-7358079a1afd"
    },{
      "LogicalName":"msdyn_requirementresourcepreference","ObjectTypeCode":10017,"MetadataId":"d63ce867-9bd1-45ee-aedc-459394bedf35"
    },{
      "LogicalName":"msdyn_rmareceiptproduct","ObjectTypeCode":10086,"MetadataId":"5b57cb66-3728-4987-8b95-ab78d5dfcf9a"
    },{
      "LogicalName":"audius_auspraegungsmerkmal","ObjectTypeCode":10153,"MetadataId":"7316e442-e883-e711-8113-e0071b6e64b1"
    },{
      "LogicalName":"msdyn_agreementsubstatus","ObjectTypeCode":10039,"MetadataId":"f6523ac8-a75c-42c3-8895-a332eb017241"
    },{
      "LogicalName":"msdyn_incidenttypeservice","ObjectTypeCode":10053,"MetadataId":"cbec0a75-621f-4a54-b4f8-c2015756b0b8"
    },{
      "LogicalName":"msdyn_paymentmethod","ObjectTypeCode":10065,"MetadataId":"871a2d4d-e21e-49d8-a26b-66a7c1325287"
    },{
.
.
.
}

Comments

Popular posts from this blog

Yet Another Address Autocomplete PCF Control–powered by Bing

In this blog post I will not go into detail in how to install all the pre-requisites that are required to build and run PCF controls. My goal was to build a new PCF control and get into coding of PCF controls as fast as possible. Here are a few links to articles that will help you installing the pre-requisites (Microsoft PowerApps CLI)  https://docs.microsoft.com/en-us/powerapps/developer/component-framework/get-powerapps-cli Other good references to get into this topic: https://toddbaginski.com/blog/how-to-create-a-powerapps-pcf-control/ https://docs.microsoft.com/en-us/powerapps/developer/component-framework/create-custom-controls-using-pcf I looked through the Guido Preite’s https://pcf.gallery/ which will help you find appropriate use cases / examples for your own needs. It did not take very long to find a simple example to start with: Andrew Butenko's https://pcf.gallery/address-autocomplete/ A few moments later I had the idea to create yet another address autocomplete

Regarding SPFieldMultiLineText (Add HTML/URL content to a field) programmatically

I recently tried so set some HTML content in a SharePoint list column of type SPFieldMultiLineText. My first approach was this piece of code: SPFieldMultiLineText field = item.Fields.GetFieldByInternalName( "Associated Documents" ) as SPFieldMultiLineText; StringBuilder docList = new StringBuilder(); docList.Append( " " ); foreach (DataRow docRow in addDocs) { DataRow[] parent = dr.Table.DataSet.Tables[0].Select( "DOK_ID=" + docRow[ "DOK_MGD_ID" ].ToString()); if (parent != null && parent.Length > 0) { docList.AppendFormat( " {1} " , parent[0][ "FilePath" ].ToString(), parent[0][ "Title" ].ToString()); } } if (docList.Length > 0) { // remove trailing tag docList.Remove(docList.Length-5, 5); } docList.Append( " " ); string newValue = docList.ToString(); item[field.Title] = newValue; What this code does is to get all associated documents to the main document and to add these docu

CRM 2016: The attribute with AttributeId = 'guid' was not found in the MetadataCache.

During the export of an unmanged solution I always received the following error message from my CRM 2016 SP1 OnPremise development system: The attribute with AttributeId = '023bda49-9dfa-401e-b348-9374a4141186' was not found in the MetadataCache. Then I tried to remember what I did since the last solution version. => Yes, there was a field that I deleted, because the customer does not need it anymore. Because I am working on-premise it was easy to check the database for the specific attribute. First, I searched in the attribute table: SELECT [AttributeId]   FROM [Dev_MSCRM].[MetadataSchema].[Attribute]   where [AttributeId] = '023bda49-9dfa-401e-b348-9374a4141186' => result was nothing I concluded CRM deleted the field in this table but missed to remove the attribute from our customer solution. Next thing was to check the solutioncomponent table: SELECT [ModifiedOn]       ,[CreatedBy]       ,[ObjectId]       ,[IsMetadata]       ,[ModifiedBy