Badrequest error 400 Onedrive for business

(0) Share

Report

Posted on by Yvalson

Hi all,

I just started using Power Automate and I'm trying to retrieve a copied file and send it per mail.

The flow copies a file from one location to another one on Onedrive and then needs to send the copied file to some users.

The first part works fine, but when I try to use "Get file content" from Onedrive for business it will throw error 400 every time.

The entire flow is not finished yet so that's why there is currently 2 branches.

Things I tried:

Creating a Test.xlsx file in Onedrive -> Selecting this file directly in Power Automate -> overwriting it with the flow -> gives error

Using dynamic content "Path" -> gives error

Writing the path manually -> gives error

using dynamic content "Id" -> gives error

using dynamic content "name" and manually writing path -> gives error

The weird thing is that I use the last method in the Run script 2 action as well and it works completely fine.

I must be forgetting something in order to fetch the file correctly, but I don't know what it is.

All responses (4)

Answers (1)

Michael E. Gernaey 44,142 Super User 2025 Season 1 on at

Like (0)

Report

Re: Badrequest error 400 Onedrive for business

Morning

You are using Get File Content, which is looking for the identifier not the path. If you want to use the path use Get File content with Path

See my example below. where id and path both come from the Copy File action

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (0)

Report

Re: Badrequest error 400 Onedrive for business

Hi @Yvalson

This is as per the design of "Get file" action of one drive connector. It accepts Id (Unique Identifier) of the file as input parameter to return the file content. Here are its details:

OneDrive for Business - Connectors | Microsoft Learn

Thanks
Yvalson 5 on at

Like (0)

Report

Re: Badrequest error 400 Onedrive for business

Thank you! worked immediately.
Just one question though.
What is the difference that makes the Excel script run using the dynamic content name while Get file content needs the Id?
Verified answer

ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (1)

Report

Re: Badrequest error 400 Onedrive for business

Hi @Yvalson

Pls pass the Id (unique identifier) from the "Create file" action in the "Get file content" to retrieve the content:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks