cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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!

1 ACCEPTED SOLUTION

Accepted Solutions
mahoneypat
Solution Sage
Solution Sage

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

2 REPLIES 2
mahoneypat
Solution Sage
Solution Sage

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Anonymous
Not applicable

Hello @mahoneypat !

 

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Kudoed Authors
Users online (4,828)