Forum Discussion
Solved
Night Shift Data
Hi!
I am currently facing an issue that I hope someone can help me with.
At the moment, I have created a SharePoint list with quite a few columns.
These shall be filled out to show data on orders.
However, I would like to have a new view created that shows only the night shift data, in the night shift time period. For example, our night shift team start at 7pm and finish at 6am the next morning.
Can I have a view to only show their inputted data from between these times? And then at 6am have the view be blank until the next night shift team come in and fill in their own data? Hopefully this makes sense.
Thanks,
Joseph.
Deleted that won't work, it will give an error because [Today] doesn't contain a time value so you can't use [Today]+19:00
JosephD13 I don't think this is possible just using views in SharePoint Online, and of course you can't use Filters like [Today] in calculated columns. But what you want to do is quite easy with a Power App using your Night Shift list as the data source. The advantage of this method is that you can quickly select the events for any night shift very quickly and it will ignore the day shift events. I've done a quick mockup & video of this which is attached. If you want the details of how to build this and the formulas that I've used just let me know.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Yes, it is possible to create a SharePoint view that displays only the data entered during the night shift time period. You can achieve this by using the built-in filtering capabilities of SharePoint views. Here's how you can set it up:
1. Go to the SharePoint list where you want to create the view.
2. Click on the "Create View" or "Modify View" option to create or edit a view.
3. In the view settings, scroll down to the "Filter" section.
4. Add a filter based on the time period for the night shift. For example, if the night shift starts at 7 PM and ends at 6 AM, you can use the following filter:
- Field: Created (or any other relevant field that captures the time of data entry)
- Operator: Greater than or equal to
- Value: [Today]+19:00 (where 19:00 is the start time of the night shift)5. Save the view with an appropriate name, such as "Night Shift Data."
Now, the view will only display the data entered during the night shift time period. Once it is 6 AM and a new day begins, the view will be empty until the next night shift team enters their data.
Keep in mind that the specific steps may vary slightly depending on the version of SharePoint you are using and the customization options available. Additionally, ensure that the time zone settings in SharePoint align with the time zone of your night shift team to accurately filter the data.
If I have answered your question, please mark your post as SolvedIf you like my response, please give it a likeDeleted that won't work, it will give an error because [Today] doesn't contain a time value so you can't use [Today]+19:00
JosephD13 I don't think this is possible just using views in SharePoint Online, and of course you can't use Filters like [Today] in calculated columns. But what you want to do is quite easy with a Power App using your Night Shift list as the data source. The advantage of this method is that you can quickly select the events for any night shift very quickly and it will ignore the day shift events. I've done a quick mockup & video of this which is attached. If you want the details of how to build this and the formulas that I've used just let me know.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)- Hi Rob!
Thank you so much for your help with this!
Could you provide me with the details as to how I can build this, including formulas etc?
You have really went out of your way to help me here! I appreciate this very much.
Thanks,
Joseph.
