Menu Close

Tag: #uk365guy

How to design Power Apps using Gallery connected to external table

uk365guy

Hello Everyone,

Today i am going to show how to create Power App using Gallery connected to external table.

This is part 3 series.

Lets gets started.

Lets login into www.make.powerapps.com

Click on the Start with a page design and select the “Gallery connected to external table”.

Once clicked on the Gallery connected to external table you will see below screen with the options to connect to external data sources like “SharePoint, Excel, SQL” to create the power app.

Selected the SharePoint as a external data source and connected to SharePoint Lists displayed in the grid and click on “CREATE APP”, so selected one of the list for this demo purpose.

As you can see from the above screenshot the Power App will be created and click on “Preview your app” button when the screen is displayed and click on PLAY button as highlighted on the screenshot.

I have selected the APPLE Iphone 11 414 x 896 (refer to the above screenshot) Power App ready to be used.

Thats it for today.

Stay tuned next part tomorrow at 11am BST.

I hope this helps.

Malla Reddy(@UK365GUY)
#365BlogPostsin365Days

Share this:

{How to design} Power Apps Page design using Gallery connected to table

uk365guy

Hello Everyone,

Today i am going to show how to design power apps using Gallery connected to table with simple clicks.

This blog post gonna be Part 2 of this series.

Lets gets started.

Let login into www.make.powerapps.com

Then you will be presented with mulitple Power Apps page design options:

Click on the Gallery Connected to table highlighted on above screenshot.

So select the table to create the data source to your app and App will be created automatically.

Once clicked on “CREATE APP” new app will be created refer to below screenshot.

You can save and play the app to interact and make changes as required.

Its that simple to create Power App with very few clicks and your app will be ready for use.

Thats it for today.

I hope this helps.

Malla Reddy(@UK365GUY)
#365BlogPostsin365Days

Share this:

Design Model Driven App or Canvas App with Page Design types from Maker Portal

uk365guy

Hello Everyone,

Today i am going to share new page design types available on Maker Portal.

This blog post gonna be Part 1 of this series.

Lets gets started.

Login into www.make.powerapps.com

Then choose the Page Design.

1. Gallery connected to table: See and use your data in a simple, single-page gallery app.

Select this option if
a) You already have business data in Dataverse
b) You want a lightweight, responsive app

Use data from Dataverse Tables.

2. Gallery Connected to external table:ee and use your data in a simple, single-page gallery app.


Select this option if
a) You already have business data in Dataverse
b) You want a lightweight, responsive app

Use data from Excel,SharePoint, or SQL.

3. Blank Canvas:

Either Tablet or Phone app.

4. View and form:

Create a collection of pages that you’ll connect to data.

For each data table you connect, you’ll get
a) One page with up to eight different data views of a table.
b) One Page with a main form for adding and updating table rows.
c) Additional forms that make working with data easier: quick view, quick create, and card forms.

Common uses
Customers building apps for Dynamics 365 frequently use this template.

Uses data from:
Dataverse tables.

5.Blank Page with Navigation:

Build an app on top of data that’s already stored in Dataverse – the smart, secure, and scalable low code data platform.

Select this option if

a) Your app needs to be usable offline
b) Your app needs to handle enterprise scale data

Use data from Dataverse tables.

6. An Image or Figma file:

Upload your app design – either made with our Figma UI KIT, or Saved in any common image file – and we’ll create an app based on that design.

Connect to data:

Once created, connect your app to Dataverse SharePoint, Excel, SQL and more.

7. Split-screen:

Just add content! This page adapts to different screen sizes, It has two sections, each taking up 50% of the screen width.

Select this option of
a) You want a lightweight responsive app.

Use data from: Once created, connect your app to Dataverse SharePoint, Excel, SQL, and more.

8. Sidebar:

Just add content! This page adapts to different screen sizes.

This Page has
a) A fixed sidebar on the left.
b) A fixed height header section
c) A main section that fills the rest of the screen width

Select this option if
a) You want a lightweight responsive app

Use data from

Once created, Connect your app to Dataverse, SharePoint, Excel, SQL and more.

9. Header, Main Section, Footer:

Just add content! This Page adapts to different screen sizes.

This page has
a) A fixed-height header on top.
b) A fixed height footer at the bottom
c) A main section that fills the rest of the screen height.

Select this option if
a) You want a lightweight responsive app

Use data from:

Once created, connect your app to Dataverse, SharePoint, Excel, SQL and more.

10. Dashboard:

Create an app to visualize data on a single page. Can connect to multiple tables and display multiple charts and graphs.

Use data from: Dataverse tables

Share this:

Create Dataverse Table and run canvas app using excel file upload(Preview)

uk365guy

Hello Everyone,

Today i am going to share new feature public preview related to upload an excel file and convert it into Dataverse table and canvas app.

Lets gets started.

Login www.make.powerapps.com

Ways to create an app:

Start with data

Create a table, pick an existing one, or even import from excel to create an app.

Click on “Start with data”

Then click on the Excel file and upload the excel file from your computer or drag and drop onto the page. Power Apps will import the first range or table in the file. Then, an app will be created for you.

Uploaded from the computer.

So the uploaded file will be created on the dataverse, As this is public preview for first 20 rows of your table, here you can change the columns how they have configured, or change the table properties to suit your needs . When everything looks good, select the Create App and a new app will be created with this data from excel file.

Edit table properties:

You can see the display name, plural name, description, primary column, schema name, you can modify them if you need to change anything and finally click on SAVE.

Row Ownership:

From the above screen shot the data can be owned by a user or team, or an organization. This is let us know who can see the data of this table. once app is created you can’t revert back.

Ownership type is selected and then click save.

Use first row as column headers:

This feature allow to choose the first row as a column name see above screenshot as an example.

Once all the configuration is updated then click ON “CREATE APP”

Then you can see the Canvas app and save it. You can Play and see with the play button highlighted on the screenshot,

When the Canvas App is played as Apple iPad Air 2020 1180 x 820 FORMAT.

Finally you can EDIT the App name and publish the app.

Thats it for today.

I hope this helps.

Malla Reddy(@UK365GUY)
#365BlogPostsin365Days

Share this:

Elements in Cards Power Apps

uk365guy

Hello Everyone,

Today i am going to share the concept of Cards in Power Apps.

Lets gets started.

Power Apps are mini app and data from dataverse(for now) and we can include the workflow, very interactive, easy to use UI elements, so other applicationw can use as content.

Power Apps cards can add and use business logic through Power Fx, it can integrate with business data through Power Platform Connectors.

We can quickly build the app and share apps without any coding.

How to start creating Cards?

Login into www.make.powerapps.com

On the hand side of the menu click more and you can see the ‘Cards’ and then PIN it to the menu, so that next time you can directly see the Cards on the menu itself.

Click on Cards(Preview)

New Card:

You will be prompted with Card designer UI.

Card designer layout:

Main Menu
Tool Pane
Card Canvas
Card
Property Pane
Formula bar
Play button

Main Menu

We can use this menu to switch between the tools available in the card designer.

Tree View: Hierarchy and view the relationship between the elements

Insert: Add Controls

Data: Add connectors to incorporate data from the external sources.

Variable: Store and reuse data.

Card Canvas and Card:

This is where we can design the cards by adding connectors, variables to your card.

Note: Cards automatically adjust themselves to the location they are placed in and we can’t resize it.

Property Pane:

Property pane to modify an element by editing its properties.

Main properties as follows:

Name
Label or Text
Default value
Initially visible.

We can customize the font color, spacing etc..

Elements have advanced properties such as:

Repeat for every: Trigger whether or when an element should be repeated.
Show when: Trigger when to show the element.
Requires: Make the element dependent on certain features with a corresponding minimum version.

Power Fx expressions can be used in some properties, creating low code solutions that make cards more powerful.

Power Fx editor and Formula bar:

We can use Formula bar to enter the Power Fx expression to automate the process (for example when a button is clicked). So the formula bar even assists you as you’re writing an expression.

Limited Power Fx expressions are working on the cards at the moment, if you need to know click here

Thats it for today.

I hope this helps.
Malla Reddy(@UK365GUY)
#365BlogPostsin365Days

Share this: