Hi Joe, great step-by-step, it's possible to cancel a Flow based on the ID item? Example, I have many requests created from SharePoint list, and I need to cancel the flow that it's associated with the ID of the list, it's possible to achieve this one? thanks in advance 👋
I had the same issue, then I checked "URL of the request" that was copied from video description and found out that there were space before "providers" and "flows" (new lines) - I deleted these spaces and process initiated correctly
Its quite hard to follow with the UI being different now but im just getting a 400 code back when calling the invoke request Action 'Invoke_an_HTTP_request' failed: The response is not in a JSON format.
You can toggle the UI back to the older version while you work on this then toggle it back. The message would suggest that either the prompt is wrong, or the response is incorrect as it’s not returning the correct information. Double check the URL.
I get a failure on the invoke an HTTP request, saying that the url is wrong. I copied the code below and added the environment id and flow id. Which connector are you using?
Invoke a HTTP request using the Get method should be all you need, you do have to provide the Base Source URL and the Azure AD Resource URI, you also need to make sure there are no spaces in the URL there should only be spaces before and after 'eq'
That's a great video - kudos 👍 If I may, just one quick question: I have a client with confidential data in a specifically permissioned SharePoint list. And this data is manipulated in a flow, and he doesn't want this data to reside anywhere uncontrolled. So, I wonder, is there a method to DELETE flow runs from the history? (if I recall correctly-it's kept there for 60 days)
You can use Secure Inputs/Outputs to hide the data in the flow run; Check out: d365demystified.com/2019/12/19/secure-input-output-in-power-automate-run-history/ alternatively you can delete the flow itself after duplicating it.
Then your response must be incorrect, go through the steps again to make sure the URL isn’t missing anything. Also check what is responded by placing it in a compose action.
I had the same issue, then I checked "URL of the request" that was copied from video description and found out that there were space before "providers" and "flows" (new lines) - I deleted these spaces and process initiated correctly
Hi Joe, great step-by-step, it's possible to cancel a Flow based on the ID item? Example, I have many requests created from SharePoint list, and I need to cancel the flow that it's associated with the ID of the list, it's possible to achieve this one? thanks in advance 👋
I am getting the below error
The response is not in a JSON format.
in the second step of invoke HTTP , Please help
Did you pass the body into a parsejson action but also use the schema?
Shown Below:
{
"type": "object",
"properties": {
"value": {
"type": "array",
"items": {
"type": "object",
"properties": {
"name": {
"type": "string"
},
"id": {
"type": "string"
},
"type": {
"type": "string"
},
"properties": {
"type": "object",
"properties": {
"startTime": {
"type": "string"
},
"status": {
"type": "string"
},
"correlation": {
"type": "object",
"properties": {
"clientTrackingId": {
"type": "string"
},
"clientKeywords": {
"type": "array",
"items": {
"type": "string"
}
}
}
},
"trigger": {
"type": "object",
"properties": {
"name": {
"type": "string"
},
"inputsLink": {
"type": "object",
"properties": {
"uri": {
"type": "string"
},
"contentVersion": {
"type": "string"
},
"contentSize": {
"type": "integer"
},
"contentHash": {
"type": "object",
"properties": {
"algorithm": {
"type": "string"
},
"value": {
"type": "string"
}
}
}
}
},
"outputsLink": {
"type": "object",
"properties": {
"uri": {
"type": "string"
},
"contentVersion": {
"type": "string"
},
"contentSize": {
"type": "integer"
},
"contentHash": {
"type": "object",
"properties": {
"algorithm": {
"type": "string"
},
"value": {
"type": "string"
}
}
}
}
},
"startTime": {
"type": "string"
},
"endTime": {
"type": "string"
},
"originHistoryName": {
"type": "string"
},
"correlation": {
"type": "object",
"properties": {
"clientTrackingId": {
"type": "string"
},
"clientKeywords": {
"type": "array",
"items": {
"type": "string"
}
}
}
},
"status": {
"type": "string"
}
}
}
}
}
},
"required": [
"name",
"id",
"type",
"properties"
]
}
}
}
}
I had the same issue, then I checked "URL of the request" that was copied from video description and found out that there were space before "providers" and "flows" (new lines) - I deleted these spaces and process initiated correctly
@@frankthevirtus indeed it helped. Thanks!
Its quite hard to follow with the UI being different now but im just getting a 400 code back when calling the invoke request
Action 'Invoke_an_HTTP_request' failed: The response is not in a JSON format.
You can toggle the UI back to the older version while you work on this then toggle it back. The message would suggest that either the prompt is wrong, or the response is incorrect as it’s not returning the correct information. Double check the URL.
you are life saver. Thanks a lot
Great video! Do you happen to have a link to the Microsoft API documentation? I would love to see what else is in there. Thanks!
I get a failure on the invoke an HTTP request, saying that the url is wrong. I copied the code below and added the environment id and flow id. Which connector are you using?
Invoke a HTTP request using the Get method should be all you need, you do have to provide the Base Source URL and the Azure AD Resource URI, you also need to make sure there are no spaces in the URL there should only be spaces before and after 'eq'
That's a great video - kudos 👍
If I may, just one quick question:
I have a client with confidential data in a specifically permissioned SharePoint list. And this data is manipulated in a flow, and he doesn't want this data to reside anywhere uncontrolled.
So, I wonder, is there a method to DELETE flow runs from the history? (if I recall correctly-it's kept there for 60 days)
You can use Secure Inputs/Outputs to hide the data in the flow run;
Check out: d365demystified.com/2019/12/19/secure-input-output-in-power-automate-run-history/ alternatively you can delete the flow itself after duplicating it.
It is saying the response from the http request is not in json format so it doesn't even reach the parse json action.
Then your response must be incorrect, go through the steps again to make sure the URL isn’t missing anything. Also check what is responded by placing it in a compose action.
I had the same issue, then I checked "URL of the request" that was copied from video description and found out that there were space before "providers" and "flows" (new lines) - I deleted these spaces and process initiated correctly
it gets only first 50 items. But what if you have 1000.
You can add a loop with an if inside, if the items returned are zero set the loop item to 1 else leave it at 0 and keep cycling through.