web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Append table with table

Power Apps

Answered

Append table with table

(0) Share

Report

Report

Posted on by kukiema

3

Hello.

I'm trying to create table to use in items property for drop down.

One table is output of filter function that is based on the source of the app.

The other table is my hardcoded values that I'd like to see in the dropdown next to the ones from filter function.

How can I append/merge them into one?

What I'm trying to do is basically this:
[1,2,3,4] + [5,6,7] -> [1,2,3,4,5,6,7]

But one of them would be result of the filter function 😛

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

VaidasG 469 on at

Like (0)

Report
Copy link

Link copied!
hi @kukiema,

Quick test I built on your requirements:

Set(varList1, [1,2,3]); Set(varList2, [4,5,6,7]);
ClearCollect(colFinalList, Blank());
ForAll(varList1 As Item, Collect(colFinalList, Item));
ForAll(varList2 As Item, Collect(colFinalList, Item));

Finally collection ColFinalList used in a dropdown as Items:

Regards
VaidasG

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

Was this reply helpful? Yes No
Verified answer

Akser 1,546 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @kukiema,

Please make the adjustments mentioned below and let me know if it works.

Ungroup( Table( { Option: RenameColumns( <YOUR FILTER FUNCTION COMES HERE>, "<THE COLUMN THAT CONTAINS THE OPTIONS COMES HERE>", "Value" ) }, { Option: [ 5, 6, 7 ] } ), "Option" )

Was this reply helpful? Yes No

Join the conversation