Answered

Displaying result of a SQL query

(0) Share

Report

Posted on by alex93jansen

101

I have a SQL Server data source named [dbo].[tmtrak_dev_records] with the field 'activityHours'. I'd like to display the result of the following query as a Label:

SELECT SUM(activityHours)
FROM dbo.tmtrak_dev_records
WHERE activityDate = '2021-02-22' AND submittedBy = 'user@email.com'

Where the activityDate value is the result of:

Today() - (Weekday(Today(), StartOfWeek.Monday) - 1)

and the submittedBy value is the result of:

User().Email

We intend to use this PowerApp as a Time-Tracking tool for our department. This query result would display how many hours a user has logged for for each day of the week (Monday in this example).

I'm struggling however with getting this to work, and figuring out if it can be done at all. I have tried various things unsuccessfully, and am just hitting a wall with this.

Any help is greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

alex93jansen 101 on at

Like
a
(0)

Report
Copy link

Link copied!
Nevermind, I found the solution myself. The following code retrieves all record for Monday (of the current week) for the current user, Sums the activityHours field and displays it as "x.xx / 8.00 hours logged"
Concatenate( Text( Sum( Filter( '[dbo].[tmtrak_dev_records]', submittedBy = User().Email, activityDate = Today() - (Weekday(Today(), StartOfWeek.Monday) - 1) ), activityHours ) ), " / 8.00 hours logged" )

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @alex93jansen :

Glad to hear that you have solved this problem.

Please consider marking your solution to a "Solution" to help others.Thanks.

Best Regards,

Bof

Was this reply helpful? Yes No