Get items filter query

(0) Share

Report

Posted on by Jonathan-101

230

Hi all,

I wonder if anybody can assist me!

I have a flow that is supposed to run at the start of each month, that filters a list for anything dated within the last month and then produces a PDF for 'each person' in the list and the list items their name appears in.

My flow is: Recurrence, Subtract time, Get items (filter query 'Date ge 'Calculated time'), Apply to each, Get items 2 (Filter query 'List column name for staff members'), Compose HTML Formatting, Select items (from Get items 2), create file, Convert file, Apply to each, Create file.

The flow works correctly until the filter in Get items 2 - SharePoint list column. It then provided the following error:

The expression "Name of person in list" is not valid. Creating query failed.
clientRequestId:

Please help!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

ryleybauer 327 on at

Like (0)

Report
Copy link

Link copied!

Hi @Jonathan-101 , are you using the true column name from the list? At a glance from your error message, usually column names aren't rendered with spaces in them.
If you go to your SharePoint list settings and click on the column (or hover your mouse over it), you'll see the formal name at the end of the URL in your browser.

Please mark as solution if this helped!

Was this reply helpful? Yes No
Jonathan-101 230 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Yea I've checked the column name and it isn't that

Was this reply helpful? Yes No
ryleybauer 327 on at

Like (0)

Report
Copy link

Link copied!

Do you have a record where that column is blank? Can you share a screenshot of the step and the error?

Was this reply helpful? Yes No