Use button to trigger Flow webhook
Hello,
I am wondering if it is possible to have a button on a sheet that when clicked would send a webhook to Flow?
I know how I'd imagine it would work, but definitely don't know VBA well enough. My thought was that when a user clicked the button, a macro would call a custom function. In the function I would grab a range and send the payload to a webhook URL monitored by Flow.
Once my data gets to Flow I know where to go from there, but any help with the VBA/Sheet side of things would be greatly appreciated!
Thanks!