You’re offline. This is a read only version of the page.
Hello- I have a flow that utilizes the trigger 'When a HTTP Request is Received'. I have placed the URL in an Excel file as a hyperlink. The Excel file is saved in a Teams channel files (and therefore Sharepoint). I also have a shortcut to the directory mapped to my desktop OneDrive. The flow works just fine, however, when the link is clicked from the file in Sharepoint, the flow triggers once (correct), but if clicked from Teams it runs twice, and if clicked from Excel desktop, it runs three times. Is there a way to configure it to only run one time regardless of the source from which it is triggered?
It worked for me when i added the trigger conditions
@not(equals(triggerOutputs()?['headers']?['Connection'], 'Keep-Alive'))
@not(equals(triggerOutputs()?['headers']?['Connection'], 'keep-alive'))
for some reason one request had it writen with upper case K and A and the other with lower case a and k
Hi
Was having a similar problem, just not from excel. Was calling from another workflow and also getting duplicate runs, but think I found the problem.
This is from the first (Correct) run:
This is for the second (Duplicate) run:
At least in our case it looks to be the keep alive that is the problem.
Adding this trigger condition solved it:
@not(equals(triggerOutputs()?['headers']?['Connection'], 'Keep-Alive'))
UPDATE:
Just found out that when you call from a flow that is not in a solution, the keep alive is also there. So this is still not a solution.
Hi!
I'm still having this issue with the HTTP trigger.
Was anyone able to bypass this issue without using macros?
The empty body solution isn't working as the output just have headers 😕
Thanks!
Hi all,
I hope that my suggestion would be helpful for you.
------------------------------------------------
I didn't use a button linked to the trigger url because of the same issue with you.
I used a macro button and the VBA code as follows.
Sub openurl()
Shell "rundll32.exe url.dll,FileProtocolHandler " & "input your Trigger URL", vbNormalFocus
End Sub
and then you will not see the trigger multiple times issue anymore.
Good luck.
Hi @jennratten
Would you please help me figure out how you could get information about the excel file? I am working on a scenario close to yours, I am triggering the flow from the excel file using a button, just trying the get the file path/name in the flow
In my configuration I'm using the link elsewhere, the original poster was using Excel. In your configuration it then seems like the flow is working correctly and it's the browser and/or the way of opening the link that is sending 2 requests quickly one after the other instead of the trigger responding twice for a single request, which was the problem I was having.
At least we were able to narrow down the problem a bit. I'm not sure how to resolve it other than trying different browsers or ways to open the link that don't result in sending the request twice.
Thanks for the quick replies. Yes on point number 2 when I paste the link directly in browser it runs perfectly and runs once. By default it opens via chrome don't think I can change the default browser.
How is yours configured? Isn't it similar to mine where you are getting the link from power automate and using it in Excel or teams?
If you're activating the flow with just a URL link and no additional parameters, which is what I think your case is, then yes the trigger condition I mentioned will apply to all of your requests and none of them will end up running because of it. I'm guessing Excel tries to open the link through the default browser. Things you could check:
The truth is even if everything in your computer is working as it should this trigger doesn't behave 100% as advertised and it's buggy. In my case I was strictly doing a single request and it still triggered twice.
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (
