You’re offline. This is a read only version of the page.
Hi,
I have a pretty simple flow that needs to update query criteria in Azure Devops and I have other automations that do variations of this. All the pieces are working but when the variable gets to the Azure Devops report, there's quotes around the variable. I've searched everywhere in Power Automate and I can't see where the quotes are being added. Conversely, running a Power Automate query to read the same Azure Devops query will show no quotes so I can't figure out how to debug this.
Is there a trick to not getting the quotes to come through?
Here is the string variable as it's sent:How the Wiql is being built and sent
I can confirm in the actions that it's not only building the variable as intended, it's sending it to Azure devops as intended and Azure Devops confirms it in the http request.
Share
Report"select [System.CreatedDate], [Microsoft.VSTS.Common.StateChangeDate], [System.Id], [System.WorkItemType], [System.Title], [System.AssignedTo], [System.AreaPath], [System.State], [System.IterationPath], [Custom.TargetGARelease], [Microsoft.VSTS.Scheduling.StoryPoints], [System.ChangedDate] from WorkItems where [System.TeamProject] = @Project and not [System.WorkItemType] in ('Shared Steps', 'Test Plan', 'Test Suite') and not [System.State] in ('Closed', 'Removed', 'Backlog', 'Released', 'Inactive', 'Completed') and [System.Id] <> 1315 and [Custom.TargetGARelease] in ('2023-04 April Release - 67.2,2023-05 May Release - 68.0,2023-06 June Release - 68.1,2023-07 July Release - 68.2,2023-08 August Release - 69.0,2023-09 September Release - 69.1,2023-10 October Release - 69.2,2023-11 November Release - 70.0') order by [System.AreaPath]"
You'll notice there's no double quotes as intended:Correct variable as intended
but when it gets to Azure devops, it looks like this:Variable arrives in ADO with double quotes
It happens every time the variable is more than 1 value. If the value is just
2023-04 April Release - 67.2
it will make it to Azure devops the same way without the double quotes but as soon as it's more than one value, it adds the double quotes. Because of the quotes the Azure Devops query won't run correctly.
Another noteworthy thing. After Power Automate sends the variable and it appears with double quotes in Azure, if I ask PowerAutomate to run that same query it just updated, power automate will not display the double quotes it just put in Azure and can be seen in azure.
Is there a trick to not getting the quotes to appear in Azure?
#1
WarrenBelz
146,618
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,962
Most Valuable Professional
All responses (
Answers (