Creating Powerapp with a Heirarchy - is it possible?

(1) Share

Report

Posted on by EricC

181

Hi All,

Some of my users are currently using an excel workbook that really just acts as a notepad, no row/column relationship, that allows them to jot down information pertaining to each item.

it's a massive spreadsheet and I can't fit all the info into one screen on a Mobile PowerApp, a tablet app would even require two screens at least. So I had the Idea of breaking it up into categories, and then each category has it's own table.

I'm no developer, but the PowerApp to me seems that it allows for a table with 1 relationship such as Client column and client items as the rest of the columns but I feel I need it broken up much more granular than that such as a heirarchy that all links back to 1 client.

The workbook they use has probably 100 item, two main categories and probably 5 subcategories under each main category.

Please see below as how I envision this heirarchy, so I have the home screen show the clients, another screen show the categories for the selected client, then a third screen show each subcategory and the fourth screen show the subcategory data fields that they can edit?

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @EricC,

Do you want to achieve your needs with one table or multiple tables within your PowerApps app?

I assume that you want to achieve your needs with multiple tables within your Excel file, you should create four Tables within your Excel file.

The first table (Table1) as below:

The second table (Table2) as below:

The third table (Table3) as below:The forth table (Table4) as below:

Within the first screen (Home Screen) of your app, you could add a Gallery control (Gallery1) to display the Clients. Set the Items property of the Gallery control to following formula:

Table1

Set the OnSelect property of the Navigate button (Button control) to following formula:

Navigate(Screen2,ScreenTransition.Fade)

Within your second screen (Screen2), add a Gallery control (Gallery2) to display the Main Category for the selected Client within your first screen (Home Screen). Set the Items property of the Gallery2 to following formula:

Filter(Table2,ClientID=Gallery1.Selected.ClientID)

Set the OnSelect property of the Navigate Button (Button control) to following formula:

Navigate(Screen3,ScreenTransition.Fade)

Within your third screen, add a Gallery control (Gallery3) to display the SubGategories for the selected MainGategory within your second screen. Set the Items property of the Gallery3 to following formula:

Filter(Table3,MainGategoryID=Gallery2.Selected.MainGategoryID)

Set the OnSelect property of the Navigate Button (Button control) to following formula:

Navigate(Screen4,ScreenTransition.Fade);EditForm(Form1)

Within your forth screen, you could add a Edit Form control (Form1), set the DataSource property to Table4, then within Fields part, select the fields (Column1, Column2, Column3,...) that you want to display.

Set the Item property of the Edit Form (Form1) to following formula:

First(Filter(Table4,SubGategoryID=Gallery3.Selected.SubGategoryID))

Add a Button control, name it as "Submit". Set OnSelect propety of the Submit button to follwoing formula:

SubmitForm(Form1)

Set OnSuccess property of the Edit Form (Form1) to following formula:

Navigate(Screen3,ScreenTransition.Fade);ResetForm(Form1)

Please take a try with above solution I provided, then let me know if it help in your scenario.

Best regards,

Kris
EricC 181 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xida-msft Thank you so much, much more detailed than I expected. This is definitely on the right path. The issue I have is there are about 100 items in table 4 and thus I'd need to create about 100 columns in table 4. Each Subcategory ID has maybe 10 items, so then based on their selection of subcategory in table 3 in the App, I need to Filter the edit form to show just those 10 items. I think there probably has to be a way to link the relevant columns to the right Subcategory, no?

Ex

I select Client > Interior > Bathroom > 10 items related to Bathroom are shown on the edit form "The edit form should show the relevant columns pertaining to the subcategory Bathroom"

or

I select Client > Exterior > Windows > 10 items related to Windows are shown on the edit form "The edit form should show the relevant columns pertaining to the subcategory Bathroom"

If I can somehow make that work, then this is pretty much exactly what I need!