Power Automate step: Upload file from URL to Onedrive

Question

I met a Problem below:
I have a Microsoft Form, and I want to get its previous responses by this button

And I want to get it Automate so I find an URL below:

https://forms.office.com/formapi/DownloadExcelFile.ashx?formid=<formID>&timezoneOffset=180&minResponseId=1&maxResponseId=1000

It works on access directly in my browser cause I already logged in to MS Form (It downloads the Excel file)
But when I use this URL in Power Automate, the response is :

{"error":{"code":"701","message":"Required user login."}}

I tried multiple ways to grant Power Automate to access the URL but none of them work
I'm searching for help. And if possible, more generally, with other websites that require login on access, what should I do

Thank you

Answer 1

Hi @HUỲNH LONG NAM ,

Please note that Power Automate is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products.

You may ask the experts in the dedicated Power Automate forum over here:
https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

----------

If the reply was helpful please don't forget to upvote and/or accept as answer, thank you!

Best regards,
Leon