web

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

News and Announcements icon

Power Platform CommunityForums Power Apps AFTER LAST UPDATE

Power Apps

Answered

AFTER LAST UPDATE

(0) Share

Report

Report

Posted on by barta

AFTER MANY YEARS PERFECT JOB and now

DO NOT WORK - Filter('[dbo].[ObedListek]';Datum>Today()) - now return empty collection - Datum is Date field in SQL table

I must change to Filter('[dbo].[ObedListek]';DateDiff(Datum;Today())<=0)) - this work fine

Next new problem

DO NOT WORK - OnSelect on any inserted element (text,button,..) in DataCard in FormViewer (pointer changed on hand, but not fired Launch("..")) on the same screen Button out of FormViewer work fine.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @barta ,

Q1:

The reason why you met this problem is that:

Direct date filters do not work for SQL Server.

However, you can create a calculated column that will work. For instance, ALTER TABLE myTable ADD DateAsInt AS (YEAR([date]) * 10000 + MONTH([date]) * 100 + DAY([date])) and then filter on the calculated number column.

For example:

Filter(AddColumns('[dbo].[ObedListek]'; "newdate"; YEAR(Datum) * 10000 + MONTH(Datum) * 100 + DAY(Datum) ); newdate>Value(ToDay()) )

Here's a doc about SQL Server connector for your reference:

https://docs.microsoft.com/en-us/connectors/sql/

Q2:

The reason why you met this problem is that you put the button inside the formviewer.

Since the formviewer's mode is View, the button's mode will change with it automatically.

So I suggest you put the button outside the form.😀

Best regards,

Was this reply helpful? Yes No

Join the conversation