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']'
You don't need to add the ODATA filter inside the expression.
You can just put it plain in the input of that field in action Get items.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
2
Share
Report
All responses (
Answers (
