web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Gallery items from dat...

Power Apps

Answered

Gallery items from dataverse table but add an item manually

(0) Share

Report

Report

Posted on by Joanna01234

7

Hi,

I want to get my items for a gallery from a dataverse table but manually add one item. How is this possible?

My code to get the items from the table is:

Distinct(Filter(TableName;Formula);Formula)

Now I just want to add one item, for example "test"

I already tried:

Distinct(Filter(TableName;Formula);Formula) & "test"

and I also tried:

Distinct(Filter(TableName;Formula);Formula) & ["test"]

But it did not work. Do you have any idea how to make it possible?

Thanks for your help!

Categories:

Building Power Apps

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

Verified answer

realwillwright 772 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Joanna01234

how many rows will you be showing in your gallery? If the number of rows doesn't introduce delegation issues you can use ClearCollect and collect to add in the extra row, ClearCollect will get all the rows from Dataverse, collect will get your extra row.

The TableColumns must match the name when using ClearCollect otherwise it will create new columns

ClearCollect(colTable, Filter(Table, formula); Collect(colTable, {TableColumn1: "", TableColumn2: "", ...})

-------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Joanna01234 7 on at

Like
a
(0)

Report
Copy link

Link copied!

I don't need much rows (maximal 10), but I already tried with Collect and it did not work properly.
I need to add the extra Item a lot of times and even if I could make it work somehow I would need a lot of collections.
Is there another option?
realwillwright 772 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I can't think of another way. I have used this method in the past and it has worked
Joanna01234 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Okay thanks for your answer!

Join the conversation