Hi,
So I've seen posts in various places about something similar to this, but I just can't seem to get it working. I have a calculated column which uses NOW() in some form which obviously doesn't update dynamically, only when the item is edited. I saw that you can get around this by using HTTP request in flow (https://365hq.net/use-microsoft-flow-to-automatically-update-calculated-column-on-a-sharepoint-list/) to update the column, however I'm coming up against an error:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN""http://www.w3.org/TR/html4/strict.dtd">
<HTML><HEAD><TITLE>Bad Request</TITLE>
<META HTTP-EQUIV="Content-Type" Content="text/html; charset=us-ascii"></HEAD>
<BODY><h2>Bad Request - Invalid Hostname</h2>
<hr><p>HTTP Error 400. The request hostname is invalid.</p>
</BODY></HTML>
clientRequestId: 30a0798e-fa5c-4a00-96a8-1c2cda0f58b5
Here is what my flow looks like:
If anyone knows why this error is coming up, or if you know another method of achieving the same outcome, that would be most helpful!
Thanks
Helpful resources
Global Power Platform Bootcamp
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Power Platform Community Conference On Demand
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
Power Automate Community Blog
Check out the community blog page where you can find valuable learning material from community and product team members!
