Unanswered

Show column's value when column name is taken from 2nd Gallery

(0) Share

Report

Posted on by rohitkushwaha

I need solution for below problem.

I'm taking column name from different table using Gallery2.selected.columnname now I want to show the Gallery2selected.columnname's value in Gallery1.

How to implement this? As for other columns we use Thisitem.columnname but ThisItem.Gallery2selected.columnname is not working.

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @rohitkushwaha,

If one specific label within Gallery 1 should reference the selected item in Gallery 2, you can reference the column value by using Gallery2.Selected.ColumnName as the Text property. (No 'ThisItem' needed, this ThisItem refers to the record within gallery1)

//Text property label in gallery 1 Gallery2.Selected.ColumnName

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!
rohitkushwaha 85 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LaurensM
Thank you for response!

In second gallery, I'm filtering the data and picking up the Week number from the filtered data then we have a column in first gallery for each week number, so we have to show the week number column.

As you suggested, I'm getting the filtered value that is 90 in all the rows, it should be 90th column values.

Text value:

Output:
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@rohitkushwaha,

The value will indeed be 90 across all rows since we reference the selected row in Gallery 2 and display the Week Number column.

What would you like to achieve by selecting 90 as a week number? Are there specific rows within gallery 1 containing '90' as a value for a specific column that you would like to display - in other words only displaying the rows of week 90? Or do you have a specific column within gallery 1 that you would like to display when 90 is selected?

Thanks!
rohitkushwaha 85 on at

Like
a
(0)

Report
Copy link

Link copied!

There are rows in Gallery1, so if the week number is 90 we want to show the below data from column 90.
For example: Gallery contains EmpName, EmpID, WeekNumber
LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@rohitkushwaha,

Thank you for the clarification. Unfortunately native dynamic column selection is not possible within Power Apps.

A possible workaround could be mimicking the dynamic behaviour via a Switch function. However, I would only recommend this approach should you have a smaller set of columns which should behave dynamically. In the example below we have 3 columns called 70, 80 and 90:

Switch( Gallery2.Selected.ColumnName, 70, ThisItem.'70', 80, ThisItem.'80', 90, ThisItem.'90' )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!
rohitkushwaha 85 on at

Like
a
(0)

Report
Copy link

Link copied!

@LaurensM
How to use switch in Addcolumn function.

Currently I hardcoded '90' but I want to use switch statement as you suggested.
rohitkushwaha 85 on at

Like
a
(0)

Report
Copy link

Link copied!
It working now.

"AllocPercent", Switch( Gallery3.Selected.'Week Number', 1, First(Grouped).'1', 2, First(Grouped).'2' )

Thanks @LaurensM