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

Whats wrong? Get items - Bad request - Sharepoint list

Hi

I've been searching for an answer to why my flow stops during this action, but I struggle to find out why.

Here's what I want to do: Populate a list in SharePoint based on an excel-document. Pretty straightforward.

 

This is how the flow looks like.

RobinA_0-1646665223192.png

This is where it fails:

RobinA_1-1646665280162.png

 

If this is to any help: here is the list:

RobinA_2-1646665362915.png

Also I can't find the internal identifier code in SharePoint for the "ticketid" that I'm trying to filter. I saw in a guide that they just hover the mouse over the column in the list or go into list settings. I'm just guessing that its "ticket_x0020_id". I don't know if this that causes this though, seems like a connection problem, but I'm able to access the list in Power automate, so this still doesn't make sense to me.


Any ideas how to fix this or what might be the cause?


Best regards,
Robin

1 ACCEPTED SOLUTION

Accepted Solutions
Bryan1979
Regular Visitor

Place single quote marks around your dynamic search term so that it reads:

 

ticket_x0020_id eq 'Ticket ID'

 

Make sure you use the dynamic search term and don't type Ticket ID

View solution in original post

2 REPLIES 2
Bryan1979
Regular Visitor

Place single quote marks around your dynamic search term so that it reads:

 

ticket_x0020_id eq 'Ticket ID'

 

Make sure you use the dynamic search term and don't type Ticket ID

RobinA
Frequent Visitor

Thank you so much!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (4,051)