Hi. I Have problems with Filter Query opcion in Get Items for a SharePoint List in Power Automate. I have using a conditions like the documentation but the flow stop with error.

Vargas Lepe Marcelo Augusto 0 Reputation points

The Error is:


The expression "RUT eq 10042567-K" is not valid. Creating query failed.

clientRequestId: 21a1de25-9211-45c5-b11a-b97d4ad32292

serviceRequestId: 21a1de25-9211-45c5-b11a-b97d4ad32292


But "RUT" is a valid column in my list. The value "10042567-k" is get it from other List.

User's image

A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,210 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Du-MSFT 39,606 Reputation points Microsoft Vendor

    Based on your description, I understand that you want to filter items which RUT column equals 10042567-K.

    You could follow below picture.

    User's image

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.