Dropdown need to show multi column values with distinct

(0) Share

Report

Posted on by NG-12101727-0

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 (2)

Answers (0)

Mark Nanneman 991 Super User 2025 Season 2 on at

Like (0)

Report

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,847 Super User 2025 Season 2 on at

Like (0)

Report
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