cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rrogerson
Frequent Visitor

Send HTTP Request to Sharepoint - The expression is not valid

I'm trying to create a simple Send an HTTP request to Sharepoint to update a value in a column.

Here is a sample of my list.

rrogerson_0-1603037423670.png

And here is the very basic flow

rrogerson_1-1603037599018.png

When I test the Flow I get an HTTP 400 error

rrogerson_3-1603037867574.png

 

I've tried to solve this myself by checking other solutions to similar problems but I can't get it to work so I'm asking the community.

 

Thanks,

 

Rob

1 ACCEPTED SOLUTION

Accepted Solutions
mdevaney
Super User
Super User

This sounds like a Power Automate question rather than a PowerApps question. I suggest you post this in the Power Automate Community instead. You’ll get a quicker and better response over there

Link to Power Automate Community
https://powerusers.microsoft.com/t5/Get-Help-with-Power-Automate/ct-p/FL_GeneralDiscussions

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

2 REPLIES 2
mdevaney
Super User
Super User

This sounds like a Power Automate question rather than a PowerApps question. I suggest you post this in the Power Automate Community instead. You’ll get a quicker and better response over there

Link to Power Automate Community
https://powerusers.microsoft.com/t5/Get-Help-with-Power-Automate/ct-p/FL_GeneralDiscussions

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

gabibalaban
Super User
Super User

Your problem came from URI: 

_api/web/lists/getbytitle('Employee')/items('00010'), where you need to use the SharePoint Item ID and not a column value.

 

Something like this:

_api/web/lists/getbytitle('Employee')/items('1')

 

 

Hope it helps !

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,714)