Hide button based on values from table

(0) Share

Report

Posted on by Abhilash M abi

106

hi, I'm trying to hide button based on values from table..

I have table called attendance in sharepoint... the button should visible only when the user checked-in previously... and checkout field is empty.. when particular user logs in application... the i need to match whether the user checked-in and forget to checked-out based on data i attendance table...

how to achieve this? help me..

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Abhilash

Don’t manage check in and check out in two different fields. Combine them in a single field called CheckedIn that is a Yes/No type column. Then set the Visible property of the button to this code:

If(ThisItem.CheckedIn=true, true, false)

---
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."

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Abhilash ,

Could you please share a bit more about the data structure of your attendance List?

Do you add a column in your attendance List to store the user display name?

I assume that there is a column in your attendance List to store the user Display name, please consider take a try with the following workaround:

Set the Visible property of the button to following:

If( !IsBlank(LookUp(attendance, UserName = User().FullName, Checkin)) && IsBlank(LookUp(attendance, UserName = User().FullName, Checkout)), true, false )

Note: I assume that there is only single one record existed in your attendance List for each user. The UserName represents the column in your attendance List to store the user name of the login user.

More details about the LookUp function, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

Best regards,

Was this reply helpful? Yes No
Abhilash M abi 106 on at

Like
a
(0)

Report
Copy link

Link copied!

No,There are multiple records for single user..

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
H @Abhilash ,

OK, I assume that you want to check if the Checkin field and Checkout field value of the latest record for the current sign in user, right?

Please try the following formula (set the Visible property of Button to following):

If( !IsBlank(Last(Filter(attendance, UserName = User().FullName)).Checkin) && IsBlank(Last(Filter(attendance, UserName = User().FullName)).Checkout), true, false )

In addition, if you want to find specific record in your SP List based on specific date, you could also consider add a Date filter condition in above Filter formula.

Best regards,

Was this reply helpful? Yes No