Hey everyone
first of all i would like to let you know that im VERY new to Power automate.
Okay so basically what i want to do is to make it so when i click on a button in my excel sheet it should run a macro that executes the flow i made in power automate
i already have made the flow and i found a piece of code on the internet which i will provide below.
My issue is that in this code it asks for a flow url but i cannot find this anywhere,i already tried going to the run history and copying the link from one of the runs but it doesn't work when the code is executed.
Sub SendMessageToTeams()
Dim url As String
Dim httpRequest As Object
' Set the URL for the Power Automate flow
url = "FLOW-URL"
' Create an HTTP request object
Set httpRequest = CreateObject("MSXML2.XMLHTTP")
' Send an HTTP POST request to the Power Automate flow URL
httpRequest.Open "POST", url, False
httpRequest.send
' Handle the response if needed
' ...
End Sub
Thank you for taking the time out of your day to read this!
