For all formula error

[TYNAI]

Hello, i have a power app that has been working well but all of a sudden it has brought some errors that i cant seem to wrap my head around, maybe i can get some assistance here!

The error happens when i click on a button that is supposed to patch a share point list.

Below are the errors

Thank you in advance

[TYNAI]

Hello @subsguts , i have another follow up question on this topic of short dates, how would you implement the short date on this kind of formula,

Text(varToday+7 - Weekday(varToday,Monday),"dddd, ") & varToday+7 - Weekday(varToday,Monday)+7

Whereby "varToday" is a variable set for "Set(varToday,Today())" , i am getting the same outcome as before whereby the date comes with time e.g 11/11/2022 12:00 AM, i would like to remove the 12:00 AM from the output using the same short date formula 

[subsguts]

You are trying to put 2 dates in a text box?  Because the date before and after the "&" is going to produce two dates and concatenate them together.

I'm sure this can be fixed, but it appears you are getting the day of the week and then adding it to another date, which combined is not a true date field.  So I think there is a different formula than what you are using that will work.  However, not knowing the purpose, hard to suggest a solution.  More info?

[TYNAI]

Hello @subsguts ,

So the purpose of the drop down would be, users are able to choose weeks of the month, i.e current week, next three weeks and last three weeks as below.

The code for this was as below

all of this was working okay until a 3 weeks ago when the update came that was showing the time after the date. Maybe this would help

[subsguts · Accepted solution]

Thanks, here you go:

Text(varToday+7 - Weekday(varToday,Monday),"dddd, ") & Text(varToday+7 - Weekday(varToday,Monday)+7,ShortDate)

[TYNAI]

Hello @subsguts , thanks again This solution worked! it reduced the days to short days as we wanted.

Still getting the intial error i had. i think ill start the app from scratch with the new date changes and see if maybe tthe date changes will help. but if you can have an idea of what going on when i try to patch the data it would help.

They are flagged as "Runtime" errors with the error checker.

[subsguts]

I would take the Lookup and break it out into a label or something since that is obviously failing to work.  Look at each part of it and make sure the comparisons make sense and the values are correctly between the informaton in the datasource and the information you are feeding it.  The WeekEndNum looks strange since I assume that is a number and yet you are formatting it with "yyyymmdd", which will not be a number.

Hope this helps.

[TYNAI]

Hello @subsguts , thank you for this. I figured that much. ill have to start the power app from a fresh with the new short date format, from the beginning and see where the issue is occurring. Thank you for taking time to assist on this. ill get back to you when i am successful