Unanswered

Using Variables to choose Column in Gallery

(0) Share

Report

Posted on by Silias

I'm just starting out and I have some trouble with my app. At the start-up I set my "CurUser" variable to my User().Email and substitute the "@" and ".".

Afterwards I am going into a "Detail Gallery" that has a filter set to a specific item ID. Now I want to have label that displays the Value of my current User (like ThisItem.CurUser) , but I can't get it to work as LookUp just returns the text value and most other things give me an Error.

Does anybody have an idea on how to approach this?

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Silias ,
If not text value what is the value you want to compare ?
Silias 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PriyankaGeethik ,

I indeed want to compare two text values. The name of the Column and my Variable, but for some reason the LookUp and likes Function don't like using a Variable for the Column Name.
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey! ThisItem.CurUser does not exist.

You have CurUser.Email or CurUser.FullName

LookUp(List; Email = CurUser.Email)

This will return the item
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Silias ,

CurUser=User().Email (eg: xyz@email.com)
This is a variable you can print in a lable but if you want this value in a gallery for all the items this will be CurUser.
But In case you want this value to Lookup any value from Gallery collection than you can use below formula
Lookup(DataSource, EmailColumnName=CurUser).ValueRequired