cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
GC1
Level: Power Up

Basic App - To contain data over a couple of pages?

Hi Everyone,

 

I am new to Powerapps and absolutley hooked, I have fair expeirence with Access and exel and just need some help with my app that i wish to build - any assistance would be greatly appreciated.

 

The App is going to contain circa 7 fields of data that is stored in an excel file on OneDrive, I cant use sharepoint as this is restricted by my company. The app users will be an internal team and they will need to be able to view the data and add if they need to.

 

The Data look like this:

 

Field 1: System - Text

Field 2: Asset Type - Text 

Field 3: Manufacturer - Text

Field 4: Model - Text

Field 5: Manufacture Date - Text

Field 6: Comments - Text

Field 7: Record Date - Date

 

So the plan is the user will land on the system page:  This has data like Electrical, HVAC, Refrigeration.... When the user selects one, then that will cascade to another screen showing only the Asset Types relevant to the System. The user then can select the Asset Type and that will cascade to another screen with all the possible Manufactures.  And it continues to flow.

 

Electrical / Distribution Board / MEM / Isobar 4 / "Last Page" Includes the Manufacturing Date, Comments and perhaps a record date.

 

So i have created all the screens and linked the data, somehow need to work how to link them up? So my first screen is System, but it seems to show duplicates which i dont want it to do.  It all looks good but doesnt function Smiley Very Happy

 

On the top of each screen i want to go back a page and the user alo has the ability to add a new record from the app.  This isn't a show stopper though.

 

Thank you for taking the time to read this and I hope that I can get some help.

 

Many Thanks,

 

GC1

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Basic App - To contain data over a couple of pages?

Hi @GC1,

 

Please first take a look at the following article:

Understand data forms in Microsoft PowerApps

Which should be helpful to get a clear understanding of how the form works in PowerApps.

 

Further, to get a distinct value, please try the following formula under the items property:

Distinct( Table, System )

For the other field in the other screen, take use of the filter function.

Filter, Search, and Lookup functions in PowerApps

 

For example, if the first Gallery is:

Distinct(Table, System)

 

Then under second screen, the items property of the gallery or Dorpdown control should be:

Distinct(Filter(Table, System=Gallery1.Select.value), AssetType)

Screen3 should be:

Distinct(Filter(Table, System=Gallery1.Selected.value&& AssetType=Gallery2.Selected.value), Manufacturer)

 

And so on.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: Basic App - To contain data over a couple of pages?

Hi @GC1,

 

Please first take a look at the following article:

Understand data forms in Microsoft PowerApps

Which should be helpful to get a clear understanding of how the form works in PowerApps.

 

Further, to get a distinct value, please try the following formula under the items property:

Distinct( Table, System )

For the other field in the other screen, take use of the filter function.

Filter, Search, and Lookup functions in PowerApps

 

For example, if the first Gallery is:

Distinct(Table, System)

 

Then under second screen, the items property of the gallery or Dorpdown control should be:

Distinct(Filter(Table, System=Gallery1.Select.value), AssetType)

Screen3 should be:

Distinct(Filter(Table, System=Gallery1.Selected.value&& AssetType=Gallery2.Selected.value), Manufacturer)

 

And so on.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (10,518)