web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Dropdown need to show ...

Power Apps

Suggested Answer

Dropdown need to show multi column values with distinct

(0) Share

Report

Report

Posted on by NG-12101727-0

4

Hello ,

I am looking for help.

I have Dataverse Table called "Table1". I have 7 columns in it with name of week days names. Like Monday, Tuesday, Wednesday ....etc

Above image is a reference.

I want to Show all the columns values has to show in power apps dropdown as a single list and distinct values as a combined. Some times columns have different than the week days also, that values also needed to show in dropdown.

Please help me out.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Mark Nanneman 993 Moderator on at

Like (0)

Report
Copy link

Link copied!

What's the point of this table? Why not delete the "Monday, Tuesday, Wednesday..." columns and replace them with one column called "Day of Week" that's a choice set for "Monday, Tuesday, Wednesday... etc"???

Was this reply helpful? Yes No
Suggested answer

ronaldwalcott 3,866 Moderator on at

Like (0)

Report
Copy link

Link copied!
Not sure why you would want to do this unless I am misunderstanding your requirements but here is an example of how to add the rows of each column to a table with one column. You would then use the Distinct function to get the unique values.

Set( TestTable, Table( { Column1: "Row1Col1", Column2: "Row1Col2", Column3: "Row1Col3", Column4: "Row1Col4", Column5: "Row1Col5", Column6: "Row1Col6", Column7: "Row1Col7" }, { Column1: "Row2Col1", Column2: "Row2Col2", Column3: "Row2Col3", Column4: "Row2Col4", Column5: "Row2Col5", Column6: "Row2Col6", Column7: "Row2Col7" }, { Column1: "Row3Col1", Column2: "Row3Col2", Column3: "Row3Col3", Column4: "Row3Col4", Column5: "Row3Col5", Column6: "Row3Col6", Column7: "Row3Col7" }, { Column1: "Row4Col1", Column2: "Row4Col2", Column3: "Row4Col3", Column4: "Row4Col4", Column5: "Row4Col5", Column6: "Row4Col6", Column7: "Row4Col7" }, { Column1: "Row5Col1", Column2: "Row5Col2", Column3: "Row5Col3", Column4: "Row5Col4", Column5: "Row5Col5", Column6: "Row5Col6", Column7: "Row5Col7" }, { Column1: "Row6Col1", Column2: "Row6Col2", Column3: "Row6Col3", Column4: "Row6Col4", Column5: "Row6Col5", Column6: "Row6Col6", Column7: "Row6Col7" }, { Column1: "Row7Col1", Column2: "Row7Col2", Column3: "Row7Col3", Column4: "Row7Col4", Column5: "Row7Col5", Column6: "Row7Col6", Column7: "Row7Col7" }, { Column1: "Row8Col1", Column2: "Row8Col2", Column3: "Row8Col3", Column4: "Row8Col4", Column5: "Row8Col5", Column6: "Row8Col6", Column7: "Row8Col7" }, { Column1: "Row9Col1", Column2: "Row9Col2", Column3: "Row9Col3", Column4: "Row9Col4", Column5: "Row9Col5", Column6: "Row9Col6", Column7: "Row9Col7" }, { Column1: "Row10Col1", Column2: "Row10Col2", Column3: "Row10Col3", Column4: "Row10Col4", Column5: "Row10Col5", Column6: "Row10Col6", Column7: "Row10Col7" } ) ); ClearCollect( myValues, {DaySpec: Blank()} ); ForAll( TestTable, Collect( myValues, {DaySpec: Column1}, {DaySpec: Column2}, {DaySpec: Column3}, {DaySpec: Column4}, {DaySpec: Column5}, {DaySpec: Column6}, {DaySpec: Column7} ) );

Was this reply helpful? Yes No

Join the conversation