Azure / LogicAppsUX

https://learn.microsoft.com/azure/logic-apps
MIT License
77 stars 81 forks source link

Dataverse connector encoding organization URL causing connection to fail #5907

Open matemora opened 1 week ago

matemora commented 1 week ago

Describe the Bug with repro steps

  1. Create new logic app
  2. Add dataverse connector (example: list rows)
  3. Try to run (connection unsuccessful) - checking cause of error show the environment has "/" and ":" encoded (from https://)
  4. Check code view, the organization is set to "organization": "@{encodeURIComponent(encodeURIComponent('https://pharmacy.crm.dynamics.com'))}"

Temporary fix: edit the connector in the code view to have only the URL, like https://pharmacy.crm.dynamics.com in the example above.

What type of Logic App Is this happening in?

Consumption (Portal)

Which operating system are you using?

MacOS

Are you using new designer or old designer

New Designer

Did you refer to the TSG before filing this issue? https://aka.ms/lauxtsg

Yes

Workflow JSON

{

"definition": {

"$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",

"actions": {

"For_each": {

"actions": {

"Update_a_row": {

"inputs": {

"body": {

"abt_name": "@join(createArray(item()?['abt_Client']['name'],substring(replace(item()?['abt_referencedate'],'-',''),1, 6)),' - ')"

},

"headers": {

"accept": "application/json;odata.metadata=full",

"organization": "@{encodeURIComponent(encodeURIComponent('https://pharmacy.crm.dynamics.com'))}",

"prefer": "return=representation,odata.include-annotations=" }, "host": { "connection": { "referenceName": "commondataservice-1" } }, "method": "patch", "path": "/api/data/v9.1/@{encodeURIComponent(encodeURIComponent('abt_enrollmentcountentries'))}(@{encodeURIComponent(encodeURIComponent(item()?['abt_enrollmentcountentryid']))})" }, "type": "ApiConnection" } }, "foreach": "@body('List_rows')?['value']", "runAfter": { "List_rows": [ "SUCCEEDED" ] }, "type": "Foreach" }, "List_rows": { "inputs": { "headers": { "accept": "application/json;odata.metadata=full", "organization": "@{encodeURIComponent(encodeURIComponent('https://pharmacy.crm.dynamics.com'))}", "prefer": "odata.include-annotations="

},

"host": {

"connection": {

"referenceName": "commondataservice-1"

}

},

"method": "get",

"path": "/api/data/v9.1/@{encodeURIComponent(encodeURIComponent('abt_enrollmentcountentries'))}",

"queries": {

"$expand": "abt_Client($select=name)"

}

},

"runAfter": {},

"type": "ApiConnection"

}

},

"contentVersion": "1.0.0.0",

"outputs": {},

"triggers": {

"Recurrence": {

"recurrence": {

"frequency": "Month",

"interval": 1

},

"type": "Recurrence"

}

}

},

"kind": "Stateful"

}

Screenshots or Videos

No response

Browser

Additional context

it doesn't affect previously created logic apps, seems to be a recent problem that is generating the wrong configuration for new logic apps.

ccastrotrejo commented 5 hours ago

Hi @matemora thanks for raising this issue. We made a new release this week, which intends to have the fix for this issue.

Could you please follow the guide to Find your session ID or portal extension version, and lets us know you Microsoft_Azure_EMA version?

The version with the intended fix should be 2.41007.1.13

Related to https://github.com/Azure/LogicAppsUX/pull/5911