cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RyoIshi731
Helper IV
Helper IV

Show Forum based on DatePicker selected date and loginuser information

Hello I am creating attendance management system and having trouble.

 

What I want to do is as follows.  I don't know how I can filter Forum, so could someone help me?  

I put the source code like this, however it doesn't get any data.

Filter(
    WorkingHour,
    WorkingDay = ModificationDate_2.SelectedDate
)

 

1. Select Date from datePicker and push Modify Button.

RyoIshi731_0-1636526577922.png

 

2. Screen is changed and Editable Forum should fetch data from Sharepoint list based on selected date in previous screen.  Also only my data should be shown here.

 

RyoIshi731_1-1636526613839.png

 

Please refer this picture for more detail.

RyoIshi731_2-1636526773376.png

 

 

RyoIshi731_3-1636526790329.png

 

 

If there is better design, please guide me.  I don't stick to this way and screen.  This is very normal attendance record system.

1 REPLY 1
Expiscornovus
Dual Super User
Dual Super User

Hi @RyoIshi731,

 

You could add a second condition in the filter to only retrieve the workingday for the current user.

 

In the example below I have also added it into a new collection.

 

ClearCollect(WorkingHours, Filter(Attendance, DatePicker1.SelectedDate = WorkingDay, User().FullName = EmployeeName));
Navigate(WorkingHoursScreen);

 

filtercollection_workingdays.png 

 

On the second screen you can just refer to the first record of that collection and retrieve the specific value of that TotalWorkingHours column.

 

First(WorkingHours).TotalWorkingHour

 

firstitem.png

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,625)