Share
Report
2Hi,
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!
Categories:
I have the same question (0)
All responses (
Answers (
