Filtering DataTable Results, wanting to offset the time range searched.

(0) Share

Report

Posted on by J_Fellows

Hello,

I'm creating a PowerApp to record data entered at the end of every shift at my place of employement.

The entry times are as follows for each shift:

First shift (7am to 3pm) enters their data at 3pm.

Second shift (3pm to 11pm) enters their data at 11pm.

Third Shift (11pm to 7am) enters their data at 7am the next day.

I can't use a datepicker to pick a date and show entries, because on a chosen day (let's say 01/13/22), it will show me the correct first and second shift entries, but the third shift entry from the previous day.

I've been trying to figure out how to offset this, but I'm stumped.

My PowerApp only has two screens - one is an entry form, the other is a datepicker with a datatable below it showing the entries from the date chosen.

Any advice would be greatly appreciated.

EDIT: The entry form saves data to a list in our Sharepoint site.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @J_Fellows ,

Could you please share more details about your scenario? What columns are there in the SharePoint list?

If users will save the entries of their shifts into the list, I suppose there should be a date value as the shift date for them to choose? If the data table is filtering on this date column, I cannot find why you have wrong results in the data table, unless it is filtering on other columns?

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
J_Fellows 13 on at

Like
a
(0)

Report
Copy link

Link copied!

The "Title" column is where they enter what shift they're on. The Date column is where they enter what date the entry is for. The rest is just Number columns based on quantities of things they've moved (inventory tracking).

My concern is we are constantly hiring in new people for the job as we're a large business and I was trying to eliminate the need for "Date" entry manually. Their shift will begin at 11pm, and the date of the entry should be marked for THAT DATE. However we're constantly having little mistakes made where the new hire enters in the date at the end of their shift, which is wrong.

I was hoping to eliminate the date entry, and filter my data table using the "Created" column. Problem is the 3rd shift entry will always be listed as the wrong date for the shift.

The entry will be created on the day AFTER the shift starts, which is incorrect.

If third shift enters their data today at 7am (2/17), it's technically the information for the shift of 2/16 (because that's when the shift started).

I feel like I'm rambling, but I hope that clears up why I'm having trouble filtering my data table.

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @J_Fellows ,

I understand your concern now. But to filter the gallery on a formatted or say processed date and time values will certainly cause delegation issue. So let's try another method. As you would like to not entering Date value manually, you can set the date column data card display mode be View and set the DefaultDate of the Date Picker within this data card to auto-populate the date based on the shift begin/end time. This will be a simple process and finally make the Gallery easy to filter on the shift date column.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Verified answer

J_Fellows 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry for the late reply, had to take some PTO and didn't have access to my laptop.

I've learned in the meantime that my issue is apparently a NON-issue. I've been trying to add functionality to the app that is going to be done in Sharepoint by creating a view for the list.

So I've moved on. I appreciate the help and suggestions and your time spent.

Was this reply helpful? Yes No