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.
Look out for new contribution recognition badges coming SOON!
Join us for the first ever Power Platform Online Conference!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!