I have a SQL data extraction and I need to filter the table by a field called "StartDate".
and the same adding ''
but none of those are working, getting the following error (If I remove the last filter everything works fine). How should I set the operator less than the Date field?
"message": "The response is not in a JSON format."
What's your StartDate Format? Most likely you need to format your utcnow in that format.
Could you please post a screenshot of the startdate how it is stored in sql. If you don't have direct access then post a runtime history of sql data. This will show how the data is stored.
Check out the on demand sessions that are available now!
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.