Power Platform Community Forum Thread Details

ODATA Filter Query using Power Apps trigger parameter

Hi,

Newbie here. I'm getting an invalid expression error in ODATA filter query for SharePoint Get Items. The flow is triggered by Power Apps and requires 4 parameters, MinimumNumber, MaximumNumber, DueMonth, and DueYear. I want to retrieve items from my KBRecurrences list where its column "DueDay" is ge MinimumNumber.

The error appears when I attempt to add the expression: DueDay ge triggerBody()?['number']. I selected MinimumNumber from the Dynamic Content and it entered the code triggerBody()?['number'] itself.

I have tried combinations of:

Changing DueDay to Due_x0020_Day. Note: DueDay the actual field name in SharePoint list settings. It's displayed as Due Day in list view.
Changing DueDay to 'Due Day' (this allowed me to add the expression, but returned Bad Request error during testing)
Using the parameter title, e.g., ge triggerBody()?['MinimumNumber']
Adding quotes around criterion 'triggerBody()?['number']'

Please help a Newbie out! :)

Thanks!