Canvas App – present grid data

This post will present a possible answer to a question I’ve recently received:

Can I present in a Canvas App a grid of data similar to what I see in an Excel spreadsheet?

By default, there is no control to allow for this functionality. The Power Apps maker interface allows you to use several controls from the Gallery, some more presentable than others. You find the Gallery option on the Insert tab, in edit mode. The following screenshot shows some of these available templates.

image

Most of these rely on a presentation that enhances the visual aspect, and lays out the elements in a friendly readable format. None of these look like an Excel grid though.

One possible approach is to take one of these layout, like the selected “Title, subtitle, and body”, and re-arrange the elements in a single line. Your line will look like the following screenshot.

image

Throw in some labels for the column headers, and your layout will look like below.

image

Using this approach, you can achieve a similar experience. There are some caveats though. For example, you can not create the horizontal scrolling functionality, your layout will only extend as far as the width of the canvas. Furthermore, you can not use a horizontal layout, as that will result in a reversal of rows and columns.

Did this help? Leave a note below!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

A WordPress.com Website.

Up ↑

%d bloggers like this: