Check two different value/text in columns of Sharepoint list and set button property based on it.

[Foxzor]

Hello!

I would like to ask a solution for the following:

I have a sharepoint list where there is a column what is contains different e-mail addresses (Column A) and an another column (Column B) what is contains the status of the item("In progress").

I have a button what I would like to set visibile if the person's e-mail address who is entered in the app equal any e-mail address in Column A and the matched item's status is "In progress' in the Column B)

This is what I figured so far: In the begginning of the app I am loading into a global variable the following:

Set(
var_My,
Office365Users.MyProfileV2().mail <- With that I will know the person's email address who entered in the app. Now, I need to compare this received e-mail address with the mentioned column A's e-mail addresses AND the status and set visible property to TRUE for the relevant button 

Thank you in advance!

[mahoneypat · Accepted solution]

One approach would be to create a collection when the app opens that gets the SharePoint list items created/modified by the current user.  You can then set your visible property based on if the count of that collection filtered with Status of "In Progress" is >0.  Or, depending on your use case, you could just have the initial collection filter on both user and status.

Pat

Pat

[Foxzor]

Hello @mahoneypat !

Thank you for your suggestion. I moved an another direction but your solution was also workable!