Show a textbox if it's Monday today

[OlaH]

I've got a week schedule but don't want to show all the times of the week at the same time. So if it's Monday today, how show "15:40" in a textbox. I like to use weekdays instead of dates if possible.

The datasource looks like this:

[Meneghino · Accepted solution]

Hi, I assume you start with a date variable, MyDate, then you can use something like this:

If( Text(MyDate, "ddd", "en-GB") = "Mon", "15:40", Text(MyDate, "ddd", "en-GB") = "Tue", "16:20", Text(MyDate, "ddd", "en-GB") = "Fri", "15:20", "16:00")

Please let me know if it works as I am going from memory.  If you are in US you can use en-US instead of en-GB

Details here:

https://powerapps.microsoft.com/en-us/tutorials/show-text-dates-times/

[OlaH]

Thank you @Meneghino!

And it's amazing what we can do, together (!), with PowerApps!

With @PKHong, as a "mentor", I've learned how to make my wish come true. 

PowerApps will truely be a game changer.

[mr-dang]

You can also try the Weekday() function. Assuming that the TextBox is part of a Gallery:

TextBox1.Text: 
ThisItem.Time

TextBox1.Visible:
Weekday(ThisItem.Date)<>2

I prefer to separate my Text and Visibility properties.

Or if you want to keep the TextBox visible for a single TextBox:

TextBox1.Text:
If(Weekday(MyDate)<>2,"15:40")

[OlaH]

Thank you mr-dang for your suggestion and you efforts to guide all of us out here!

The code looks very neat but I can't get it to work. Probably cause I don't really understand it.

Yes, I want one textbox, visiable all the time but showing different times every day.

MyDate?

When I tried your second idea I got an error. I used my textbox, "DagTB", as "MyDate". Look at the picture down below.

Was that a misstake?

<>2

What does this do?

(I'm trying to learn and understand, not just making it work with your help.)  

Two datasources in one gallery?

I made it with Meneghino's suggestion but in that case I had all the times in the same datasource as the gallary. I'd rather have it in a another datasource, "Scehdule". Like in the picture above. Is that possible? 

What do I write instead of "15:30" in that case?

[mr-dang]

Hi @OlaH,

I forgot to explain how Weekday() worked in my last post. 

Weekday can detect which day of the week a given date is and it returns a number. 

Weekday(Today()) is going to return 1 since today is Sunday.

Sunday returns 1
Monday returns 2
Tuesday returns 3
Wednesday returns 4
Thursday returns 5
Friday returns 6
Saturday returns 7

There's more advanced things you can do with Weekday if you don't want 1 to be Sunday--like if you wanted 1 to be Monday. The Weekday() function can take the same arguments as it does in Microsoft Excel.

After seeing your picture, I think I know what you can do to show the only the times you want.

First, I made a mistake in my last post. I thought you wanted to show all the times that was NOT Monday. When you see the symbol "<>", that means Not. So I was using the formula to show all the times where the Weekday is not 2, which means Monday. As an aside, you can also use ! in front of arguments to also express Not.

Overall, you can ignore my last post since it would not apply to your situation.

For your situation, I assume you have one datasource with the names of all your employees, Employees, and you want to have a second datasource with the times, Schedule.

One best practice I would suggest is to write your Schedule table so that the name of the weekday is not the column name since it's hard to operate on the name of a column in PowerApps. Instead, if you place the names of the weekdays into records, you can detect them. I added a Code column to correspond to the name of the weekday. This makes it easier to look it up later.

Schedule

WkDay		TimeStart	Code
Monday		15:40		2
Tuesday		16:20		3
Wednesday	16:00		4
Thursday	16:00		5
Friday		15:20		6

You can set DagTB to be Today() or set it to a DatePicker1.SelectedDate depending on whether you want it to show today's date or a date you select in a date picker.

I am not sure how you have your Employees set up. I would set the Gallery1.Items to Filter your Employees to only show the ones who work on that day:

Filter(Employees, [condition that only shows employees who work on DagTB])

Inside Gallery1, set the TextBox you have for showing the Time to:

First(Filter(Schedule,Code=Weekday(DagTB))).TimeStart

This means, "In the TextBox, show the time for the first record in the Schedule datasource where the date in DagTB matches the Code column." So if DagTB is a date that is Wednesday, then Weekday(DagTB) will return 4, and look up 4 in the Code column in the Schedule datasource to return "16:00." 

The formula for time will work if all employees have the same time. If each employee has a different time, then some more information will be needed in the Schedule datasource.

[OlaH]

Hi mr-dang

I love to learn and therefor I'm so greatful for all your guidance and know I understand Weekday() much better.

My app is for a after school center and the 250 kids ("Emplyees") have many different time that they leave. The solution I got from Meneghino gets the work done.

There is always a problem when we who needs help define the issu. Since we don't know what to do we often miss information thats needed. I'm sorry if I misslead you @mr-dang but want to thank you for sharing your knowledge.

Ola