You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Apps Select Query on postgr...

Power Apps

Unanswered

Select Query on postgresql error

(0) Share

Report

Posted on by EF-11100438-1

Attempting a date query from a postgresql database to try and get all rows where the date is past a specific day.

Attempting a Select Query i have tried the below which works fine running the query against the database itself, but in the flow gives an error:

select * from timesheets where date >= '2024-10-07'

error:

"Term 'select * from timesheets where date >= '2024-10-07'' is not valid in a $select or $expand expression.

I have also tried using ODATA querys like

date gt 2024-10-07

and

date gt 2024-10-07T00:00:00Z

and these gives no error but also returns no results.

Note that the date format in the database is 'YYYY-MM-DD' in a date column, if i allow the query to get all results, the date column is returned as '"date": "2024-10-02"'

Categories:

Building Power Apps

I have the same question (0)

All responses (0)

Answers (0)

Join the conversation

Community site session details

Select Query on postgresql error

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates

Community site session details

Select Query on postgresql error

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Apps

Featured topics

Product updates