topic Get data from feature layer Query on Date in ArcGIS Connectors for Power Automate Questions

Get data from feature layer Query on Date

MJune — Fri, 07 Jun 2024 15:22:24 GMT

I am trying to use the Get data from feature layer to bring back any records that have been created in the last seven days. Every time I try to query on a date file I receive an error "Cannot perform query. Invalid query parameters". If i query the Feature Layer on a field that is not date, i have not issues. It is only when I attempt to query on the date fields. I have tried using the Available Fields/Comparison Type/Search Parameter Value and the Where fields to do this. Does anyone have any ideas?

Below are some screen shots of my flow steps with the formula's shown.

Re: Get data from feature layer Query on Date

PavelJilinski — Tue, 11 Jun 2024 17:55:11 GMT

Hi,
Could you please check a couple of things:
1. If you use the drop-down and select the field "Created_date" does it work?
2. What is the datatype of the field created_date?

From your query, it seems that you are likely passing a Unix Epoch (integer) to a date-type field.

Re: Get data from feature layer Query on Date

MJune — Wed, 12 Jun 2024 20:25:01 GMT

I attempted to use the drop-down and select the field, that did not work either. The created_date is a "Date" field. I was attempting to use a regular date format without success. When i pull back all records, the created_date field is in the Unix Epoch format

Re: Get data from feature layer Query on Date

Pavel148 — Thu, 20 Jun 2024 19:17:51 GMT

Hello,
Thanks for your feedback. I was able to reproduce and identify the issue.
You need to provide the date as a string, such as '2024/01/23'. See the example below.

Please, for now, add single quotation marks (') around the date: for example: '2024/02/14'.