question

HUNHLONGNAM-3251 avatar image
0 Votes"
HUNHLONGNAM-3251 asked LeonLaude edited

Power Automate step: Upload file from URL to Onedrive

I met a Problem below:
I have a Microsoft Form, and I want to get its previous responses by this button
126323-image.png
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



not-supported
image.png (27.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LeonLaude avatar image
0 Votes"
LeonLaude answered

Hi @HUNHLONGNAM-3251,

Please note that Power Automate is currently not supported in the Q&A forums, the supported products are listed over here https://docs.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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.