Unanswered

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

(0) Share

Report

Posted on by Community Power Pla...

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!

Categories:

Process mining

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

mahoneypat 1,720 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello @mahoneypat !

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

Was this reply helpful? Yes No