Hey all,
I am struggeling with a query based on a Power Automate call, triggerd by When a HTTP request is received. Although I already added the Timeout parameter to the Web.Contents, I receive a Timeout error at Power Automate after 5 minutes runtime. The error appears on the response action. Do you have any suggestions what I is missing here?
(queryEndPoint as text) as table =>
let
url = WebHookTriggerUri,
body = "{""service"": ""httpByAzure"",""endpoint"": """&queryEndPoint&"""}",
Parsed_JSON = Json.Document(body),
BuildQueryString = Uri.BuildQueryString(Parsed_JSON),
Source = Json.Document(Web.Contents(url,[Headers = [#"Content-Type"="application/json"], Content = Text.ToBinary(body),Timeout = #duration(0,0,120,0)])),
#"Converted to Table" = Record.ToTable(Source),
#"Transposed Table" = Table.Transpose(#"Converted to Table"),
#"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table", [PromoteAllScalars=true]),
#"Expanded value" = Table.ExpandListColumn(#"Promoted Headers", "value")
in
#"Expanded value"
error on Power Automate
The execution of template action 'Response' is failed: the client application timed out waiting for a response from service. This means that workflow took longer to respond than the alloted timeout value. The connection maintained between the client application and service will be closed and client application will get an HTTP status code 504 Gateway Timeout.
