Date Time format from Powerapps

(0) Share

Report

Posted on by niklasjegg

505

Hello. I want to add a Filter query to my SP Get items function useing A flow triggered in powerapps.

I have 2 Date pickers where i want to att 2 different dates that are being checked with my Date column.

my Formula looks like this right now. My Date Column in SP is of the Format 07/12/2021

How can i achieve this in the filter query?

Set(varReport, "(Deadline gt '" & Text(DateGreaterThan.SelectedDate,"yyyy-mm-ddThh:mm:ss") & "') and (Deadline lt '" & 
 Text(DateLessThan.SelectedDate,"yyyy-mm-ddThh:mm:ss") & "')")

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

niklasjegg 505 on at

Like (0)

Report
Copy link

Link copied!
Im sorry. i Have checked what format the get items function is useing and it was the wrong format than it is dispalyed.
it works with this.
Set(varReport, "(Deadline gt '" & Text(DateGreaterThan.SelectedDate,"yyyy-mm-dd") & "') and (Deadline lt '" & Text(DateLessThan.SelectedDate,"yyyy-mm-dd") & "')")

Was this reply helpful? Yes No