Why day of week is not showing?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@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... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for replying. It is a text column.
Gulf_man

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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