web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Powerapps with Mysql -...

Power Apps

Answered

Powerapps with Mysql - select on date column

(0) Share

Report

Report

Posted on by Pirocab

4

Hi,

We start with Powerapps and we use Mysql like database.

The connection is well done. We can make an insert in the table.

But when we want to select a row , we can't use the date column for the select.

For example :

We would like to do this kind of request : Select * from buildtmpmobileapp where dated = "18-09-2023"

We tried with something like :

Set(homeWorkingUp;LookUp('assar.buildtmpmobileapp'; dated = Today()))

or

Set(homeWorkingUp;LookUp('assar.buildtmpmobileapp'; dated = Date(2023;09;18)))

or

Set(homeWorkingUp;LookUp('assar.buildtmpmobileapp'; dated = DateValue(Text("18-09-2023"))))

Here's the structure of our table and one line:

Could you help us ?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-jefferni on at

Like (0)

Report
Hi @Pirocab ,

According to my knowledge, in PowerApps Canvas you'll need to convert SQL date/time column to Text then be able to filter on it.

Set(homeWorkingUp;LookUp('assar.buildtmpmobileapp'; Text(dated;ShortDate) = Text(Today();ShortDate)))

In you App, you can use a Label and set Text as

LookUp('assar.buildtmpmobileapp'; !IsBlank(dated)).dated

then in the formula bar, it will tell you the data type of this value in PowerApps. Based on the result, you can determine what to do the next step.

Best regards,

Was this reply helpful? Yes No
Pirocab 4 on at

Like (0)

Report

@v-jefferni You rock, thanks !!

Was this reply helpful? Yes No

Join the conversation