Why day of week is not showing?

Like (0) Share

Report

Posted on 26 Feb 2019 21:36:09 by Community Power Pla...

All,

Newbie question. Why is this not returning dayOf Week?

I need to insert dayOfWeek into a sharepoint list via a powerapp interface.

I tried the following code:

Set (dayOfWeek, Text(Weekday(Now())));

If (dayOfWeek="1", 
 "Sunday", 
 dayOfWeek="2",
 "Monday", 
 dayOfWeek="3",
 "Tuesday",
 dayOfWeek="4", 
 "Wednesday");

When I check the list, it is inserting as 1 , 2 or in Tuesday case 3. Why is it not inserting Tuesday or any other weekday?

Any hint is greatly appreciated.

Thanks,

Categories:

General Questions

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

RandyHayes 76,289 Super User 2024 Season 1 on 26 Feb 2019 at 22:03:30

Like (0)

Report
Re: Why day of week is not showing?

@Anonymouscan you provide more about where you are putting your formula? Is this on an Update property?
Also, is the SharePoint column a Text column or Choice?

Also, you might want to consider just using the following formula:
Text(Now(), "dddd")
This will return the full name of the weekday for the date (in this case Now(), but you can put any date in there).

Hope this helps some.

Was this reply helpful? Yes No
Community Power Pla... on 26 Feb 2019 at 22:36:10

Like (0)

Report

Re: Why day of week is not showing?

Thanks for replying. It is a text column.
Gulf_man

Was this reply helpful? Yes No
Community Power Pla... on 26 Feb 2019 at 22:40:16

Like (1)

Report

Re: Why day of week is not showing?

Thanks. It looks like it is working. I got this Text(Weekday(Now())) from microsoft site.
Thanks for you help.

Was this reply helpful? Yes No
RandyHayes 76,289 Super User 2024 Season 1 on 26 Feb 2019 at 23:21:24

Like (0)

Report

Re: Why day of week is not showing?

@Anonymousvery good. However, I thought you were trying to get to an actual formal day name, not a number.
The Weekday function will return a number.
The Text(Now(), "dddd") function will return a formal name (no long If statement to choose the formal name - just a single statement).

Was this reply helpful? Yes No