cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Populate Gallery pane with static values rather than from datasource

Hi,

 

I am populating a gallery to show my SharePoint list items based on Status field. I have created 2 galleries and populated successfully.

 

The left gallery, I am using SharePoint status field. However the gallery is creating entries based on number of records in SharePoint List.I have 6 items in list and hence it shows 6 panes in left gallery.

 

Is there anyway, where I can show standard static values "Approved", "Submitted","Rejected" and based on that show entries on right gallery ?

 

Also , anyway we can maximize the height of each pane in left gallery, so that it gets equally distributed and looks perfect ?

Pic6.PNG

3 REPLIES 3
Highlighted
Super User
Super User

Re: Populate Gallery pane with static values rather than from datasource

@Kumar9024021 

I have 2 ideas for you.

 

#1  If you always want Approved, Rejected, Submitted to show put this code in left-menu Items property

["Approved","Submitted","Rejected"]

 

#2  If you only want values to show that appear on the right-menu use this code in your left-menu

Distinct(Gallery1.AllItems,Status.Value)  //this assumes Status is a Choice field

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Highlighted
Advocate I
Advocate I

Re: Populate Gallery pane with static values rather than from datasource

Have the Gallery on the left pointing at a Collection containing records with the names 'Approved', 'Submitted', and 'Rejected'. This way it will only show these 3 records.

 

Then filter the Sharepoint Gallery on the right based on a variable ('statusVariable'), which is set every time you click on either Approved/Submitted/Rejected (set it to 'Approved' when you click on Approved, which will then filter the list based on this value).

Highlighted
Community Support
Community Support

Re: Populate Gallery pane with static values rather than from datasource

Hi @Kumar9024021 ,

 

The left gallery:

Set Items property: ["Approved","Submitted","Rejected"], the left gallery will only show these three static value

 

The right gallery:

If you want to show all items based on the selected status, set the Items property: Filter('SP list', Status.Value=LeftGallery.Selected.Value) 

 

You can click to the first item of gallery and click the circles in the four corners to resize the gallery.

Annotation 2019-11-27 160223.png

Best regards,

Sik

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Users online (4,788)