Date formula is not working

[lolla70]

Hi All

I created a Sharepoint List that include "Check In Date" and "Next Check In Date"

I have a button in the App on "TEXT" I wrote 

If(IsBlank(LookUp('Back to Work Eligibility', Employee.Email=VarUserEmail)),
"Check in Required",
"Next Check-In Date " & Text(DateTimeValue(Text(First('Back to Work Eligibility'). 'Next Check-In Date' )), "[$-en-US]mm/dd/yyyy"))

On other button the Patch

Patch(
'Back to Work Eligibility',
Defaults('Back to Work Eligibility'),
{
Title: "Status from " & User().FullName & " on " & Now(),
'Check-In Date': Now(),
'Eligibility Status': EmployeeEmail,
Result: lblResult.Text,
'POC Name': ThisItem.'Employee Name'.DisplayName,
'Next Check-In Date': DateAdd(
Now(),
Value(varCheckInDays),
Days
),

The button is not updated the Next Date Button on the APP

When I change the formula to "Last" instead of First it works but then all my colors change to black. Cause I need to get the last Next Check - In Date. In the SharePoint it works but it is not updating in the App????

If(IsBlank(LookUp('Back to Work Eligibility', Employee.Email=VarUserEmail)),
"Check in Required",
"Next Check-In Date " & Text(DateTimeValue(Text(Last('Back to Work Eligibility'). 'Next Check-In Date' )), "[$-en-US]mm/dd/yyyy"))

Any idea??

On other button the Patch

[RandyHayes]

@lolla70 

Please consider changing your Text Formula to the following:

If(
    !LookUp('Back to Work Eligibility', Employee.Email=VarUserEmail, true),
        "Check in Required",
        
        "Next Check-In Date " & 
            Text(
                First(
                    SortByColumns(
                        Filter('Back to Work Eligibility',
                            Employee.Email=VarUserEmail
                        )
                        'Next Check-In Date',
                        Descending
                     )
                ), 
                ShortDate
             )
)

I hope this is helpful for you.

[lolla70]

It didn't work

[RandyHayes]

@lolla70 

Please scrub through the formulas I provide as I type them by hand without the aide of a design editor - there are sometimes syntax issues.

Updated formula is:

If(
    !LookUp('Back to Work Eligibility', Employee.Email=VarUserEmail, true),
        "Check in Required",
        
        "Next Check-In Date " & 
            Text(
                First(
                    SortByColumns(
                        Filter('Back to Work Eligibility',
                            Employee.Email=VarUserEmail
                        ),
                        'Next Check-In Date',
                        Descending
                     )
                ).'Next Check-In Date', 
                ShortDate
             )
)

[lolla70]

Tried everything nothing working

[RandyHayes]

@lolla70 

Can you provide some more details on what you have tried and what is or is not working at this point?  It is very difficult to know your entire app and data source information without further details. 

Your original post had an image of your list (assuming that is the 'Back to Work Eligibility' list) with the Title, Check in and next check in.  You then reference an unseen column called Employee - I assume this is a Person column - yet you are not setting that column in your Patch formula.  I had assumed you were perhaps doing that someplace else, but if not, this will not give you any results for your formula.

My assumption was that you wanted to show the MOST recent Next Check In Date record value for the Employee.  So, again from above, if you are not setting the Employee column in your patch, then you will never be able to get that value.

Am I missing something with your scenario?

[lolla70]

Here what I have, I have a record for Employee.

[RandyHayes]

@lolla70 

That all looks fine, but my question remains...where are you setting the Employee column?  It is not in your original Patch formula.

[lolla70]

Do you mean this? 

Patch(
'Back to Work Eligibility',
Defaults('Back to Work Eligibility'),
{
Title: "Status from " & User().FullName & " on " & Now(),
'Check-In Date': Now(),
'Eligibility Status': EmployeeEmail,
Result: lblResult.Text,
'POC Name': ThisItem.'Employee Name'.DisplayName,
'Next Check-In Date': DateAdd(
Now(),
Value(varCheckInDays),
Days
),
Employee: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & Lower(Office365Users.MyProfile().Mail),
Department: Office365Users.MyProfile().Department,
DisplayName: Office365Users.MyProfile().Mail,
Email: Office365Users.MyProfile().Mail,
JobTitle: Office365Users.MyProfile().JobTitle,
Picture: ""
}
}
);

[lolla70]

Hi

I cleared the Cache memory on my Edge Explorer, then changed the "First" to "Last" seems it is working now. Hopefully will keep it working. I will check tomorrow if it will change the date. Thank you so much. finger crossed

If(IsBlank(LookUp('Back to Work Eligibility', Employee.Email=VarUserEmail)),
"Check in Required",
"Next Check-In Date " & Text(DateTimeValue(Text(Last('Back to Work Eligibility'). 'Next Check-In Date' )), "[$-en-US]mm/dd/yyyy"))