cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lolla70
Helper IV
Helper IV

Date and Text Label Result not working! Please help

Hi 

I really need your help, I gave up😥

The Next Check-In stopped working when the result is "Work from home". When I logged out and log in to the APP I should see the Result Message and the Date till next day, however it is showing to start from beginning. How I fix this issue?

The Next Check-In OnText Code

With({_email: User().Email},

"Next Check-In Date " &

If(lblResult_1.Text = "Work from Home",
DateAdd(Today(), 1, Days),
If(!LookUp('Back to Work Eligibility', StartsWith(Employee.Email,_email),true),
"Check in Required",
With({_records: SortByColumns(Filter('Back to Work Eligibility',StartsWith(Employee.Email,_email)), "NextCheck_x002d_InDate", Descending)},
Text(
With({_utc: First(_records).'Next Check-In Date'},
DateAdd(_utc, TimeZoneOffset(_utc), Minutes)
),
ShortDate
)
)
)
)
)

 

The Work from Home OnText Code 

If(
IsBlank(ListBox3_1.Selected.Value),
"Well-check Status Required",
If(
ListBox3_1.Selected.Value = "Home",
"Work from Home",
ListBox4_1.Selected.Value = "Yes",
"Work from Home, contact HR",
ListBox5_1.Selected.Value = "Yes",
"Work from Home, contact HR",
ListBox5_2.Selected.Value = "Yes",
"Work from Home, contact HR",
ListBox5_2.Selected.Value = "No",
"Clear for Office/Field work"
)
)

lolla70_2-1614259153205.png

 

 

 

 

 

13 REPLIES 13
RandyHayes
Super User
Super User

@lolla70 

According to the formula, if your Label shows "Work from Home", then you should be seeing Today's date plus on day.  Is that the part that you are stating is not working?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Yes that is correct. I can see it but when I logged out from the APP and open again, the "Work from Home Message" and Check-in turn like new record and I want the message and the date to be seen and still there till Next check-in date

RandyHayes
Super User
Super User

@lolla70 

It seems like this would hinge on the ListBox3_1 as that is what causes your Label to display "Work from Home".  After that, the formula on the Next Check In is all based on that label.  What is that listbox about and how is it set up?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

For the ListBox there is 3 choices, based on the choice it will go to the next question till the confirmation, EXCEPT the "Home" selection. 

OnSelect Code

If("Home" in ListBox3_1.Selected.Value, Navigate(scrMain, ScreenTransition.Fade), lblResult_1);

 

the Confirmation Button OnSlecet Code

With({_user: User()},

Patch(
'Back to Work Eligibility',
Defaults('Back to Work Eligibility'),
{
Title: "Status from " & _user.FullName & " on " & Text(Today(), ShortDate),
'Check-In Date': Today(),
'Eligibility Status': EmployeeEmail_1,
Result: lblResult_1.Text,
'Working Location': lblWorkingFrom_2.Text,
'Office Location': ThisItem.Title,
'Next Check-In Date': DateAdd(Today(), 1, Days),
Employee: {
Claims: "i:0#.f|membership|" & Lower(_user.Email),
Department: "",
DisplayName: _user.Email,
Email: _user.Email,
JobTitle: "",
Picture: ""
}
}
)
);
Navigate(scrMain, ScreenTransition.Fade);

 

 

RandyHayes
Super User
Super User

@lolla70 

Yes, but what I am saying is that your original Formula for what is displayed in the button text is based on lblResult_1.Text which according to the formula on that control is based on the ListBox3_1.Selected value.  

 

So, before more confusion....is the Label "Work from Home" correct in your picture?

If it is, then your Formula for that check in text button says that it should show Today's date plus 1 day.

Is that incorrect, and in what way?  

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Yes that is correct, It is based on the lblResult_1 OnText Code

If(
IsBlank(ListBox3_1.Selected.Value),
"Well-check Status Required",
If(
ListBox3_1.Selected.Value = "Home",
"Work from Home",
ListBox4_1.Selected.Value = "Yes",
"Work from Home, HR",
ListBox5_1.Selected.Value = "Yes",
"Work from Home, contact HR",
ListBox5_2.Selected.Value = "Yes",
"Work from Home, contact HR",
ListBox5_2.Selected.Value = "No",
"Clear for Office/Field work"
)
)

RandyHayes
Super User
Super User

@lolla70 

So, based on everything you are saying:

- lblResult_1.Text is based on ListBox3_1.Selected (still don't know what that is) and it is Displaying "Work from Home"

- Your formula on the CheckIn button text is based on lblResult_1.Text, and if it is Work from Home, then it will display Today's date plus 1

 

So...what is the issue?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!
lolla70
Helper IV
Helper IV

ListBox3_1

onItem 

["Office", "Field", "Home"] 
OnSelect

If("Home" in ListBox3_1.Selected.Value, Navigate(scrMain, ScreenTransition.Fade), lblResult_1);

 

My issue is 

1) the Next Check-In Date when the Home got selected "Work from Home, it just show one time and it didn't stay till next day ie. select Home and I got the Work from home message the next day shows as Next Check-In 2/26/2021 when I close the App and sign in the date is no longer there. I need to keep seeing the date till 2/26/2021. Also I need to keep showing the lbl message till next day

2) If for example I get "Contact HR" or "Clear to Work" message, the next day keep showing till next day because we are patching it. However the Message don't stay till next day. 

So I need to FIX 2 the text message to stay till next day even if exit the APP, so if sign in back the same day I want to see it.

As well I need to see the Next sign in Date till next day especially for the Work from Home cause the other are working cause we are patching it.

 

RandyHayes
Super User
Super User

@lolla70 

 

1) the Next Check-In Date when the Home got selected "Work from Home, it just show one time and it didn't stay till next day ie. select Home and I got the Work from home message the next day shows as Next Check-In 2/26/2021 when I close the App and sign in the date is no longer there. I need to keep seeing the date till 2/26/2021. Also I need to keep showing the lbl message till next day
Yes, so again, there is nothing in your formula chain (button to label to listbox) that would do anything except what you are seeing.  I see no place that you would be setting things back to how they were when the app closes.  Ideally, it sounds like what you really need to do is have your listbox show the last value selected (which you can't do with a listbox) and, somewhere along the line, record that the person actually selected something so that when your app starts again, it will know that something was already selected for the day.

 

2) If for example I get "Contact HR" or "Clear to Work" message, the next day keep showing till next day because we are patching it. However the Message don't stay till next day. 

So I need to FIX 2 the text message to stay till next day even if exit the APP, so if sign in back the same day I want to see it.

As well I need to see the Next sign in Date till next day especially for the Work from Home cause the other are working cause we are patching it.

This is not how your formula is currently written.  The message is based on your Listbox selection (which again, you cannot set) and the label is based on what is in that listbox, and the check in button text is then based on that label.  So, it's not possible to achieve what you want with that logic.  It will need to be adjusted based on what you are trying to accomplish.  You will need to lookup the stored values you have set in your list and then make determinations based on that stored value.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (5,650)