convert sql using Power Apps filter

(1) Share

Report

Posted on by usaman45

314

Hi,

I need help on below sql script convert into Power App formula, but not sure what to do it, please help.

Thanks!

Select T.Date, T.Time, T.Name, T.Overwrite
From Tbl T
Where
Not Exists (
Select 1 From Tbl D
Where D.Overwrite='true' And T.Overwrite='false'
And D.Date=T.Date And D.Time=T.Time
)
Order By T.Date

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

CU-18081211-6 9,270 Moderator on at

Like (1)

Report

@usaman45 ,

if your data resides in a SQL database isn’t be easier to define a view in your database and connect it to PowerApps app ? Am I miss something ?

Was this reply helpful? Yes No
usaman45 314 on at

Like (0)

Report

I know it will be easy but the data source is in SharePoint list.

Was this reply helpful? Yes No