You’re offline. This is a read only version of the page.
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!
Hello @mahoneypat !
Thank you for your suggestion. I moved an another direction but your solution was also workable!
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
Share
Report
All responses (
Answers (
1,720