cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ashokpershad
Kudo Kingpin
Kudo Kingpin

Button Visibility

I have one gallery named "glryReport" . 

This gallery have three Columns named: Report#, Name and Status.

There is one Button which once pressed should take the user to next screen.

I want the visibility of this button should be:

True: only when the last saved Status of same Report# is "Re-Check"

False: when the last saved Status of same Report# is either "Submitted" or "Approved"

ashokpershad_0-1634468569706.png

Kindly suggest what command shall i use?

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

Hi @ashokpershad,

Do you want to check the status of the same Report#?

Could you please tell me that how you set the Items property of the Gallery?

 

If the Gallery populated with the SP list, I think you could sort the records by the Created ascending. Then check the last status of the record.

Set the Items of the Gallery as below:

Sort(DataSource,Created,Ascending)

To show last item filtered out as per search Report#, you could set the Items of the Gallery as below:

Sort(Search(DataSource,SearchBox.Text, Report#),Created,Ascending)​

Set the Visible property of the Button as below:

Last(Sort(Search(DataSource,SearchBox.Text, Report#),Created,Ascending)​​).Status="Re-Check"
Best Regards,
Qi

View solution in original post

3 REPLIES 3
gabibalaban
Super User
Super User

@ashokpershad ,

Use on Visible property:

Last(Gallery.AllItems).Status = “Re-Check”

@gabibalaban  as per your advice this will show with respect to last Report# submitted but what I need is, should show last item filtered out as per search Report#. 

v-qiaqi-msft
Community Support
Community Support

Hi @ashokpershad,

Do you want to check the status of the same Report#?

Could you please tell me that how you set the Items property of the Gallery?

 

If the Gallery populated with the SP list, I think you could sort the records by the Created ascending. Then check the last status of the record.

Set the Items of the Gallery as below:

Sort(DataSource,Created,Ascending)

To show last item filtered out as per search Report#, you could set the Items of the Gallery as below:

Sort(Search(DataSource,SearchBox.Text, Report#),Created,Ascending)​

Set the Visible property of the Button as below:

Last(Sort(Search(DataSource,SearchBox.Text, Report#),Created,Ascending)​​).Status="Re-Check"
Best Regards,
Qi

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,451)