You’re offline. This is a read only version of the page.
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
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
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.
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.
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
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?
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 This is Amazing and very helpful, seems like a "feature" by all intentions.
We learn a new thing every day, Text(DateValue(Label6) -6,ShortDate) this is good and has solved my problem. Thank you for taking your time with this, I am indebted.
Kind regards
@TYNAI , yes, I tested this out and that is indeed the case.
Here's my labels:
The first one is hardcoded as "11/01/2006"
The second one: "DateValue(Label6) -6"
The third one: Text(DateValue(Label6) -6,ShortDate)
So, I think it's a "feature" 🙂 of doing math on a date, which has to be taken into account.
Good catch!
@subsguts maybe a follow up to this, i have noticed the displayed time 10/24/2022 12:00 AM only comes when i do an arithmetic subtraction of days from the formula DateValue(lblSelectedDate.Text) i.e i want to subtract 6 days from this hence the formula will read DateValue(lblSelectedDate.Text) -6, when the 6 is added the this is when the output adds the unwanted 12:00 AM in there, this was not there in the beginning when the app was working fine. Maybe you can have an idea whats going on
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (
