Forum Discussion

wm-thompson's avatar
wm-thompson
Brass Contributor
May 07, 2024

https://powerusers.microsoft.com/t5/Building-Power-Apps/Help-expand-and-develop-more-content-on-a-Mi

I am working on making a Microsoft Power App that uses data to fill a form.
I have used the following tutorial:
 
Fundamentally, it demonstrates creating a blank Power App and then adding a From
to the Power App canvas and connecting the Microsoft List to the form.
 
It seems to be an App for submitting a new record to the Microsoft List.
But what if I want simply to display the data of a Microsoft List in a list
in the Power App?  Instead of an app where the user inputs a row into a
Microsoft List by using a Power App, how would I create an App which only
displays the data currently in the Microsoft List?  How would that be done?
 
I asked our friendly neighborhood Bing AI Copilot and here is what she said:
 
Certainly! If you want to create a Power App that displays data from a Microsoft List without allowing users to input new records, you can follow these steps:
 
1. Create a Canvas App with Data from Microsoft Lists:
You can create a canvas app directly from within Power Apps using data from a Microsoft List. The app will contain three screens:
Browse Screen: This screen allows users to scroll through all items in the list.
Details Screen: Shows detailed information about a single item in the list.
Edit Screen: Allows you to create a new item or update existing item information.
You can apply these concepts to any list in SharePoint.
Here’s how to create the app:
1. Sign in to Power Apps.
2. From the home screen, choose one of the following options:
To create a single-page gallery app with a responsive layout:
Select Start with data > Create with SharePoint List.
Or, choose Start with a page design > Gallery connected to external data > From SharePoint.
To create a three-screen mobile app:
Select Start with an app template > From SharePoint.
3. If you haven’t already created a SharePoint connection, you’ll be prompted to do so. Enter the SharePoint URL and connect.
4. Select a list and then choose Create app.
5. Your app opens in Power Apps Studio, where you can design, build, and manage it.
6. Give your app a name and save it1.
2. Displaying Data in the App:
Once you’ve created the app, you can display the data from your Microsoft List using controls like galleries or data tables.
For example, you can insert a data table control on a screen and set its Items property to the name of your SharePoint list (e.g., 'Travel Requests').
When you provide the list name to the Power Apps data table, all the SharePoint columns and records will appear in the table.
Customize the app further by adding filters, sorting, and other features as needed2.
 
Remember that you can always preview your app and make additional changes before sharing it with others. Good luck with your Power App development! 😊👍
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
I was able to create a Microsoft Power App using these steps.
 
Now I have some questions.
 
What was automatically generated is a good starting point but I want to provide the user some information based on some calculations from the individual record they are looking at.
 
Is there a way to drop a container into this section on the right side of the page such that all of the other displays are moved down?
Inside this area, I want to have three check boxes with the title A, B and C where, depending on the calculations made on the record, one of the three corresponding check boxes is checked.
 
I would also like to know how I can make this app such that it is not the only page.  I would like to have perhaps a couple more page with similar content that the user can choose to view.
SharePoint
  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor
    May 09, 2024

    wm-thompson I assume you have answered your first question via CoPilot and now know about galleries.

     

    Your second question - "Is there a way to drop a container into this section on the right side of the page such that all of the other displays are moved down?" No because you can't put a container inside a form. But you can have several forms on the same screen all linked to the same selected item in the gallery and just display in each one the fields you want.

     

    So in the screenshot below there are 4 containers. The vertical gallery, which I've renamed to galPilots, is inside the far left container. The middle container contains the first form, but not all the columns, only a subset of them. The bottom right container also contains a form with our columns from the SharePoint list but again only has some of the fields..

     

    For both of these forms the item property is  galPilots.Selected

     

     

     

    So the 4th container in the top right has the 3 checkboxes which, in this example, just checks the checkbox based on the flight hours in the last 12 months, for example checkbox B has the Checked property set to 

    If(Value(dataFlightTime.Value) > 100 && Value(dataFlightTime.Value) < 500, true, false)
     
    In the gallery item OnSelect property I've just set  a variable to the firstname and lastname: 
    Set(varPilot, lblName.Text) and will use this on the next screen.

     

    Your 3rd question - "I would also like to know how I can make this app such that it is not the only page.  I would like to have perhaps a couple more page with similar content that the user can choose to view."

    Having multiple screens is a normal part of any app. So add a new screen from the link on the left:

     

    Then to navigate between screens add a button and in the OnSelect property enter for example Navigate(scrSupplementary, ScreenTransition.Fade)

     

    On the new screen I've added a container and a form and set the item property of the form to the same galPilots.Selected as before and chosen the fields to display. For the label showing the pilot's name the Text property of the label references the variable so is "Supplementary Information for "&varPilot

     

     

    Come back with any questions about this.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

Resources