cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
niklasjegg
Resolver I
Resolver I

Date Time format from Powerapps

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") & "')")

 

1 ACCEPTED SOLUTION

Accepted Solutions
niklasjegg
Resolver I
Resolver I

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") & "')")

 

View solution in original post

1 REPLY 1
niklasjegg
Resolver I
Resolver I

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") & "')")

 

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,753)