cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Celia
Helper I
Helper I

Another post about: This formula uses scope, which is not currently supported

Hi all,

 

I found so many, but I cannot translate them to my situation.

 

Some columns work fine with ThisItem, but some don't:

 

LookUp column (Table: Action | Column: Actiehouder)

Choices (Table: Action | Column: KPI)

 

(Name of my primary column: Action Number)

 

I use Dataverse. 

Celia_0-1654545739238.png

 

Can someone tell me what I need to do?

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

Hi @Celia,

D o you want to display LookUp column value within Gallery or DataTable?

 

 

vqiaqimsft_2-1654675867430.png

Note that 'Lulai Tracker' is my Dataverse table including a LookUp column named 'The Food'.

Actually, if you want to access to LookUp column value, you should reference to the column where you retrieve the value from the related table.

vqiaqimsft_1-1654675763767.png

So you should set the Text property of the Label within the Gallery as below:

ThisItem.'The Food'.'Food Name'

vqiaqimsft_3-1654675983967.png

On your side, you should modify as below:

ThisItem.Actiehouder.ColumnInRelatedTable

 

Best Regards,
Qi

View solution in original post

3 REPLIES 3
WarrenBelz
Super User
Super User

Hi @Celia ,

Here is an article on dealing with Dataverse Option Sets

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

v-qiaqi-msft
Community Support
Community Support

Hi @Celia,

D o you want to display LookUp column value within Gallery or DataTable?

 

 

vqiaqimsft_2-1654675867430.png

Note that 'Lulai Tracker' is my Dataverse table including a LookUp column named 'The Food'.

Actually, if you want to access to LookUp column value, you should reference to the column where you retrieve the value from the related table.

vqiaqimsft_1-1654675763767.png

So you should set the Text property of the Label within the Gallery as below:

ThisItem.'The Food'.'Food Name'

vqiaqimsft_3-1654675983967.png

On your side, you should modify as below:

ThisItem.Actiehouder.ColumnInRelatedTable

 

Best Regards,
Qi
Celia
Helper I
Helper I

@v-qiaqi-msft  Thank you, it makes so much sense now!! Thank you!

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,117)