Power Apps

Display a collection in a table layout

(2) Share

Report

Posted on by petewalburn

185

Hi,

I have a collection which has the following structure:

Column, Row, Label, Data

and data such as:

1, 1, "Number", "1"

1, 2, "Class", "Class 1",

1, 3, "Type", "Type 1",

2, 1, "Status", "Open"

3, 1, "Stage", "First"

This collection can grow or shrink.

I want to be able to display this collection in a table-like display:

Number 1 Status Open Stage First

Class Class 1

Type Type 1

The column and row can me modified by the user, thus changing the position within the table.

I had thought that I could use a gallery with a Wrap count set as the number of columns available. But I can't figure out how to do it now. I've tried with containers inside the gallery and only show the container if the ThisItem.Column = appropriate column.

Could I iterate through the collection on Row order and create labels dynamically with the appropriate x and y coordinates?

Maybe it can't be done in Power Apps, in which case I will have to give up on this idea.

Any help would be appreciated.

Thanks,

Pete

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

MichaelFP 2,001 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

You collection is too big?

If not you can use the component HTML text and show as table using html.

-----------------------------
If my answer helped you, please give me a thumbs up (👍).
If solve your question please mark as answer ✔️. This is help the community.
If you want talk with me just tag me @MichaelFP

Was this reply helpful? Yes No
Suggested answer

Haque 3,653 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi@petewalburn

Do you need something like this? I could format your sample in PowerApps - Canvas App just a draft mode.

Now, can you please complete your requirement in table?

Is this exactly you want?

Was this reply helpful? Yes No
petewalburn 185 on at

Like
a
(0)

Report
Copy link

Link copied!

Haque

Close, but what I would want from that input data is:

As Number, Class and Type are in column 1, but Status is column2 and Stage is in column 3.

Pete

Was this reply helpful? Yes No
Haque 3,653 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @petewalburn,

Two things to consider:

1. Column and Row range - can you please tell me how many column and rows will be theres - is it something your input (your first sample table or the Input table I drawn for you) rows are incremental and columns are fixed?

2. Can you please draw full table with data to make sure how the output table will look like. I understand Status (col-2) and Stage (col-3) columns. I just need to be clear, if any rows increases how these two columns data will look like.

Thanks.

Was this reply helpful? Yes No
petewalburn 185 on at

Like
a
(0)

Report
Copy link

Link copied!

There will be a maximum of 3 columns, could be many rows.

The rows and columns can be changed by the user. I have a context menu button next to each label which allows the user to move it up, down, right or left.

So, the input data could be:

and this would give an output of:

Pete

Was this reply helpful? Yes No