https://community.esri.com/t5/arcgis-connectors-for-power-automate-questions/best-way-to-filter-by-date-using-get-data-from/m-p/1329827#M366 <P>I would like to get data based on date.&nbsp; I have thought of two methods but have yet to test them out and think there must an easier day.&nbsp; Here are my methods:</P><P>&nbsp;</P><P>1. Using Available Fields to compete the date field with a unix time stamp.</P><P>2. Using the Where clause to filter through all records and get my results.</P><P>&nbsp;</P><P>I would think there would be a more streamline way to retrieve records by date - get todays records.</P><P>Any ideas?&nbsp; Thanks!</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="TL2_0-1695067904285.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/80967i1E1C486CEFAEA834/image-size/medium?v=v2&amp;px=400" role="button" title="TL2_0-1695067904285.png" alt="TL2_0-1695067904285.png" /></span></P><P>&nbsp;</P> Mon, 18 Sep 2023 20:12:03 GMT TL2 2023-09-18T20:12:03Z https://community.esri.com/t5/arcgis-connectors-for-power-automate-questions/best-way-to-filter-by-date-using-get-data-from/m-p/1329827#M366 <P>I would like to get data based on date.&nbsp; I have thought of two methods but have yet to test them out and think there must an easier day.&nbsp; Here are my methods:</P><P>&nbsp;</P><P>1. Using Available Fields to compete the date field with a unix time stamp.</P><P>2. Using the Where clause to filter through all records and get my results.</P><P>&nbsp;</P><P>I would think there would be a more streamline way to retrieve records by date - get todays records.</P><P>Any ideas?&nbsp; Thanks!</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="TL2_0-1695067904285.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/80967i1E1C486CEFAEA834/image-size/medium?v=v2&amp;px=400" role="button" title="TL2_0-1695067904285.png" alt="TL2_0-1695067904285.png" /></span></P><P>&nbsp;</P> Mon, 18 Sep 2023 20:12:03 GMT https://community.esri.com/t5/arcgis-connectors-for-power-automate-questions/best-way-to-filter-by-date-using-get-data-from/m-p/1329827#M366 TL2 2023-09-18T20:12:03Z https://community.esri.com/t5/arcgis-connectors-for-power-automate-questions/best-way-to-filter-by-date-using-get-data-from/m-p/1373529#M515 <P>Puedes utilizar la opción "where" colocando esta exprecion</P><P>EditDate&gt;='@{body('Convertir_la_zona_horaria')}' AND (Actividad_Realizada='@{triggerOutputs()?['body/feature/attributes/Actividad_Realizada']}')<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Usando el Where.jpg" style="width: 489px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/92528i98B8C43DA1751E29/image-size/large?v=v2&amp;px=999" role="button" title="Usando el Where.jpg" alt="Usando el Where.jpg" /></span></P> Tue, 23 Jan 2024 17:13:45 GMT https://community.esri.com/t5/arcgis-connectors-for-power-automate-questions/best-way-to-filter-by-date-using-get-data-from/m-p/1373529#M515 SeguridadSPRBUN 2024-01-23T17:13:45Z