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
2023-07-27T15:57:42.0833333+00:00

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

SharePoint
SharePoint
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
    2023-07-28T09:25:59.55+00:00

    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.