Label Text with If Condition

(0) Share

Report

Posted on by LA-27081519-0

231

I need your assistance with this formula

I have a label text the get the Result from the SharePoint

I want to start the Label with Ready to Work Check Required, then go look at the last record for the employee and get the result from the Result Column

I put on the ONTEXT Code this formula, however it is getting the Data for Last Employee checked in. I want to data for my record only how I can do that.

With({_email: User().Email},
If(!LookUp('Back to Work Eligibility', StartsWith(Employee.Email,_email),true),
"Ready to Work Check Required",

With({_records: SortByColumns(Filter('Back to Work Eligibility',StartsWith(Employee.Email,_email)), "NextCheck_x002d_InDate", Descending)},
Text(
With({_utc: First(_records).Result},
If(!IsBlank(Last('Back to Work Eligibility').Result), Last('Back to Work Eligibility').Result)
)
)
)
)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

Vijay Tailor 2,961 on at

Like (0)

Report
Hi @lolla70 ,

you can Add the Another Lookup/Filter Condition inside the Last Function.
like if you want the only record is related to you then Add Filter Condition Like CreateBy = User().Email
See below your code.

With({_email: User().Email},
If(!LookUp('Back to Work Eligibility', StartsWith(Employee.Email,_email),true),
"Ready to Work Check Required",

With({_records: SortByColumns(Filter('Back to Work Eligibility',StartsWith(Employee.Email,_email)), "NextCheck_x002d_InDate", Descending)},
Text(
With({_utc: First(_records).Result},
If(!IsBlank(Last('Back to Work Eligibility').Result), Last('Back to Work Eligibility').Result)
)
)
)
)
)

See the Approach for Display the Data Related to you.
Code -
Last(Filter(TSMasterData,'Created By'.Email= User().Email,Title).Title).Title
Thanks,
Vijay
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay

Was this reply helpful? Yes No
LA-27081519-0 231 on at

Like (0)

Report

Hi @VijayTailor
How do I reset the lblResult when it is the next day to come back to "Ready to Work Check Required"

With({_email: User().Email},
If(!LookUp('Back to Work Eligibility', StartsWith(Employee.Email,_email),true),
"Ready to Work Check Required",

With({_records: SortByColumns(Filter('Back to Work Eligibility',StartsWith(Employee.Email,_email)), "NextCheck_x002d_InDate", Descending)},
With({_email: First(_records).Result},
If(!IsBlank(Last(Filter('Back to Work Eligibility', 'Created By'.Email = User().Email, Result).Result).Result), Last(Filter('Back to Work Eligibility', 'Created By'.Email = User().Email, Result).Result).Result)
)
)
)
)

Was this reply helpful? Yes No
Verified answer

Vijay Tailor 2,961 on at

Like (0)

Report

@lolla70
if the record is created on a Daily basis then add one more condition in the filter like Created = Today().
then Automatically Label will Updated the Values-Based on data found.

Was this reply helpful? Yes No
LA-27081519-0 231 on at

Like (0)

Report

Thank you so much for replying. When I added the Created = Today() the screen get black and I need to have on in Ready for Work Check Required"!!! Did I added correct?

With({_email: User().Email},
If(!LookUp('Back to Work Eligibility', StartsWith(Employee.Email,_email),true),
"Ready to Work Check Required",

With({_records: SortByColumns(Filter('Back to Work Eligibility',StartsWith(Employee.Email,_email)), "NextCheck_x002d_InDate", Descending)},
With({_email: First(_records).Result},
If(!IsBlank(Last(Filter('Back to Work Eligibility', 'Created By'.Email = User().Email, Created = Today(), Result).Result).Result), Last(Filter('Back to Work Eligibility', 'Created By'.Email = User().Email, Created = Today(), Result).Result).Result)
)
)
)
)

Was this reply helpful? Yes No
LA-27081519-0 231 on at

Like (0)

Report

Any help to finish my APP would be appreciated.

When I added the Created = Today() the screen get black and I need to have on in Ready for Work Check Required"!!! Did I added correct?

With({_email: User().Email},
If(!LookUp('Back to Work Eligibility', StartsWith(Employee.Email,_email),true),
"Ready to Work Check Required",

With({_records: SortByColumns(Filter('Back to Work Eligibility',StartsWith(Employee.Email,_email)), "NextCheck_x002d_InDate", Descending)},
With({_email: First(_records).Result},
If(!IsBlank(Last(Filter('Back to Work Eligibility', 'Created By'.Email = User().Email, Created = Today(), Result).Result).Result), Last(Filter('Back to Work Eligibility', 'Created By'.Email = User().Email, Created = Today(), Result).Result).Result)
)
)
)
)

Was this reply helpful? Yes No