HTTP Request to SharePoint - Bad Request 400

(0) Share

Report

Posted on by F_Quint

257

Hi,

I'm trying to update a single field in a SP list, I have but I keep getting this error and I'm at a loss in regards to what to do next.

This is my flow.

then I get the following error

"status": 400,

"message": "The expression \"web/lists/GetByTitle('NAVIA Customer Engagement Request')/items({3478})\" is not valid.\r\nclientRequestId: 3ad7c6fb-30ff-44a3-8a51-052815331938\r\nserviceRequestId: 16c66e9f-d08d-a000-d56c-30297dfc533c",

My Sharepoint List URL:

https://SPsite.com/sites/EIS/CustomerEngagement/Lists/NAVIA%20Customer%20Engagement%20Request/Find%20a%20Request1.aspx

any pointers would be greatly appreciated!!!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello @F_Quint

Have you tried using the base URL that you shared. I believe this is happening from spaces in your URI

Try replacing the spaces with %20

Was this reply helpful? Yes No
F_Quint 257 on at

Like (0)

Report
Copy link

Link copied!

@Jcook thanks for the reply.

I tried adding the %20 in lieu of the spaces and I'm still getting the same error 😞

Was this reply helpful? Yes No
Verified answer

Jcook 7,781 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @F_Quint

I was able to get it working.

For spaces in the URI %20 does work

But for spaces in the Body for the Metadata type than you must use _x0020_ for the spaces.

Now if you want to get this value dynamically, you can use 2 http calls like below:

Than I am using a parse JSON:

I put {} as the schema so I can run the flow and get sample data to generate from sample

than my second http call looks like this:

I am grabbing type from the parse json

My Successful run:

Was this reply helpful? Yes No
F_Quint 257 on at

Like (0)

Report
Copy link

Link copied!

@Jcook Thank you so much for taking the time to try on your end.

I followed the steps you added and I got a new error message,

Was this reply helpful? Yes No
F_Quint 257 on at

Like (0)

Report
Copy link

Link copied!

@Jcook Please disregard my last post. I missed /item on my Get post now I got the right body parsed.

Thank you so much your solution really helped me!

Was this reply helpful? Yes No