Answered

Use Gallary to select Sharepoint List for Another gallary

(0) Share

Report

Posted on by gizmobrat

Hello,

I am making my admin tables to allow for in app edits for dropdowns that exist throughout my app. As most of the sharepoint lists consist of a single collum called Title, I am attempting to reuse the same gallery control to reduce the number of Items I have to recreate. My admin screen consists of 2 galleries, a menu which has a defined list of items listed below, and the gallery where the edits are made. The lists I wish to edit are defined as part of the table function under "AdminListName" The aim is to have the second gallery pull the SharePoint list name from the 1st gallery named Admin_Menus run the Items command below. I am getting errors as the app is reading the table name as a text vaule.

Admin_menu (Select the table to edit)

SortByColumns(Filter(
 Table(
 {
 AdminMenuText: "Users",
 AdminMenuLevel: 5,
 AdminMenuOrder: 0,
 AdminSingleColumn: false,
 AdminListName: "Admins_for_Tracker"
 },{
 AdminMenuText: "Fiscal Year",
 AdminMenuLevel: 1,
 AdminMenuOrder: 1,
 AdminSingleColumn: true,
 AdminListName: "FYs"
 }{
MORE TABLES TO EDIT EXIST HERE
}
 ),AdminMenuLevel <= var_admin),"AdminMenuOrder",SortOrder.Ascending)

GAL_Admin_Single_Column (Gallery to be used when a single Item column exists)

SortByColumns(Filter(Admin_Menus.Selected.AdminListName,StartsWith(Title,Admin_Search_Box.Value)),"Title",SortOrder.Ascending)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

MudassarSZ365 591 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @gizmobrat ,
Switch( Admin_Menus.Selected.AdminListName, "Admins_for_Tracker", SortByColumns(Filter(Admins_for_Tracker, StartsWith(Title, Admin_Search_Box.Value)), "Title", SortOrder.Ascending), "FYs", SortByColumns(Filter(FYs, StartsWith(Title, Admin_Search_Box.Value)), "Title", SortOrder.Ascending), // ...additional cases for each list... SortByColumns(Filter(AllItems, StartsWith(Title, Admin_Search_Box.Value)), "Title", SortOrder.Ascending) // Default case if none match )

Was this reply helpful? Yes No
gizmobrat 63 on at

Like
a
(0)

Report
Copy link

Link copied!

@MudassarSZ365,
Thanks for the quick reply.
1. Where would I place this formula?
2. What would be the best way to reference the selected table for my patch, reset, and edit controls?
-gizmobrat

Was this reply helpful? Yes No
MudassarSZ365 591 on at

Like
a
(0)

Report
Copy link

Link copied!
@gizmobrat ,
However, you can use a workaround by having a condition based on the selection that changes the data source of your gallery. You'll need to write out each potential data source in your code. Below is an example using the Switch function, which could be used in the Items property of your GAL_Admin_Single_Column gallery:
Switch( Admin_Menus.Selected.AdminListName, "Admins_for_Tracker", SortByColumns(Filter(Admins_for_Tracker, StartsWith(Title, Admin_Search_Box.Value)), "Title", SortOrder.Ascending), "FYs", SortByColumns(Filter(FYs, StartsWith(Title, Admin_Search_Box.Value)), "Title", SortOrder.Ascending), // ...additional cases for each list... SortByColumns(Filter(AllItems, StartsWith(Title, Admin_Search_Box.Value)), "Title", SortOrder.Ascending) // Default case if none match )
In the above code:
Replace Admins_for_Tracker and FYs with the actual names of your SharePoint lists (these should be the internal names used in Power Apps to refer to those lists).
Admin_Menus.Selected.AdminListName is the text value from the selected item in your Admin_menu gallery, which you're using to determine which SharePoint list to display in GAL_Admin_Single_Column.
AllItems in the default case should be replaced with a generic or error-handling scenario, or you can choose to return an empty table like Table().

Was this reply helpful? Yes No
gizmobrat 63 on at

Like
a
(0)

Report
Copy link

Link copied!

Last Question,
If I have some buttons that exist outside the gallery, would I need to hard code this switch option also?

Was this reply helpful? Yes No