Hi,
I have 3 tables which I linked using relationships:
- Consultants
- Training history
- Training list
From the training history entity I have 2 relationships 'many-to-one' to the other 2 tables.
I first select a consultant, then I want to see which trainings he has followed.
The second gallery is shown the trainings correctly via Items: Gallery2.Selected.'Training Histories'
But I can't show the lookup columns like 'ThisItem.'Training ID' -> expected text value (see attachment).
I also tried to show the training name which is present in the training list entity via
LookUp('Training List','Training ID'=ThisItem.'Training ID','Training Name')
This gives the error 'invalid argument type'.
Any help would be great! Thanks
Kr
Solved! Go to Solution.
Hi @ThomasVDS
ThisItem.LookUpField.'Training ID'
LookUp('Training List','Training ID'=ThisItem.LookUpField.'Training ID','Training Name')
Hi @ThomasVDS
ThisItem.LookUpField.'Training ID'
LookUp('Training List','Training ID'=ThisItem.LookUpField.'Training ID','Training Name')
@yashag2255Thank you, it worked!
For the training ID -> ThisItem.'Training ID'.'Training ID'
For the Training Name I even didn't need to do a lookup -> ThisItem.'Training ID'.'Training Name'
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
14 | |
5 | |
4 | |
4 | |
3 |
User | Count |
---|---|
20 | |
6 | |
6 | |
5 | |
4 |