Flow Failing on "Get Task Instance Duplicate" — BadRequest Error

(0) Share

Report

Posted on by PJ-30030607-0

Hi all,

I have a scheduled flow called “Generate Recurring Task Instances”. The flow is failing consistently, and the failure seems to originate from a SharePoint "Get items" query inside my loop.

Failing Action

Get_Task_Instance_Duplicate

Error Type: BadRequest

Filter Query Used

TaskLookupIdId eq 1 and TaskDate eq '2026-03-28'

Action Inputs

Site: https://numerix.sharepoint.com/sites/GlobalTeam

List Name: 79b6bc09-9eaf-48d7-9c84-a2e02a42d039

What Happens

This step fails with BadRequest.

As a result, all dependent actions fail, and the entire flow run stops.

Earlier steps (Get items, Compose, Select, etc.) succeed.

Looking for Help

Can someone help identify why this SharePoint Get Items query is failing?

Is the filter query syntax incorrect, or could the column types (lookup/date) be causing the issue?

Thanks in advance!

Categories:

Building flows

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

chiaraalina 2,425 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi

I think this could be happening because the OData filter doesn’t match the actual SharePoint column schema.

Also, TaskLookupIdId looks suspicious. What is the internal name of your lookup column?

If the internal name is TaskLookup, then the filter would usually be:
TaskLookupId eq 1

Is TaskDate a Date Only column or a Date and Time column?

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@PJ-30030607-0,

Power Automate (Filter)

https://www.powerapps911.com/post/filtering-sharepoint-data-with-odata-queries-in-power-automate

Go to the list → List settings → click the lookup column → check the URL in the browser. You’ll see something like:...Field=TaskLookupId, that is the internal name.

If internal name is TaskLookup → filter using TaskLookupId eq 1

If internal name is already TaskLookupId → filter using TaskLookupIdId eq 1

If internal name is something else (like Task) → filter using TaskId eq 1

for the time use ISO datetime -

formatDateTime(utcNow(),'yyyy-MM-ddT00:00:00Z')

Now combine both and revert it worked or not.

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No