Unanswered

Choice Column Help: Days and times of operation within a business

(0) Share

Report

Posted on by THowkins96

I am currently in the process of bringing our company data into Dataverse across from SharePoint. One of the things we want to capture is our unit's days and hours of operation.

For example, for one unit (the row) we would want to say:

Monday 08:00 - 16:00
Tuesday 08:00 - 16:00
Wednesday 08:00 - 16:00

Thursday 08:00 - 16:00

Friday 08:00 - 13:00
Saturday 08:00 - 12:00
Sunday Closed

What would be the best way to capture this in tables? For days of the week I was thinking we could do a multi choice column with the days of the week but how would we capture the time to correspond to the days as each day may have a different operating hour?

The only think I can think of is to have 14 columns, an open and close time column for each day, but that seems quite a long way around it?

Can anyone help me with a better solution?

Many thanks

Tom

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @THowkins96,

Could you please share a bit more about your scenario?

Do you want to have separate columns to display start time and end time?

If you want to have separate columns to display the start time and end time, like 08:00 and 16:00, I think you just need to create 3 columns, Weeday column to select from Monday to Sunday, StartTime and EndTime.

Was this reply helpful? Yes No
THowkins96 88 on at

Like (0)

Report

Hi @v-qiaqi-msft

We are a catering business, so some of our sites will have different operating hours through the week, the most common of which being an earlier close on a Friday. This is why I don't think it's possible for us to have only 3 columns, as if we were to do a multi choice on weekday and then StartTime and EndTime then we would not be able to differentiate between different service times on different days.

Hope that makes sense?

Thanks,
Tom

Was this reply helpful? Yes No