get item filter

(0) Share

Report

Posted on by NH-24041710-0

Hi,

I need to check if records meeting a criteria exist before I add a new item (if they do I'll delete). My source is a sharepoint list and the fields I'm wanting to check are "Sprint Number", "Approval State" which is a Choices field and "Requested Approver" which is a Person field.

All records will have a Pending state and both Sprint Number and Requested Approver have been stored in a compose variable "Sprint Num" and "Sprint Approvers".

I've used CoPilot having exhausted my knowledge and still get various errors (if it even lets me save the flow).

Any help on my Filter Query?

Cheers,

Neil

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Vish WR 3,748 on at

Like
a
(2)

Report
Copy link

Link copied!
@NH-24041710-0

Use SharePoint internal column names and correct field formats in your Filter Query.

Eg:

Choice field → Approval_x0020_State eq 'Pending'

Person field → use Email

Requested_x0020_Approver/Email eq 'user@domain.com'

Sprint Number → Sprint_x0020_Number eq 'value'

Was this reply helpful? Yes No
Ellis Karim 12,163 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@NH-24041710-0

As @Vish WR has mentioned, use the internal name of the SharePoint column.

See: How to Find the Internal Name of a SharePoint Column (Step-by-Step Guide) – Ellis Karim's Blog

For filtering on the email address, email must be upper case E and M:

Ellis Karim
elliskarim.com | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
Coopedup 355 on at

Like
a
(2)

Report
Copy link

Link copied!

Both very helpful. I found that prior to me getting the SP List the columns must have been renamed, so the reference name was different to the display name. Rather that trying to remember that for future me and others, I recreated the columns.

Now working on using a variable in the get items rather than hardcoded.

Was this reply helpful? Yes No
Vish WR 3,748 on at

Like
a
(1)

Report
Copy link

Link copied!

@NH-24041710-0

Thanks for the update

Vishnu WR

LinkedIn - My Tech Space

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥

Was this reply helpful? Yes No