web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Choices This.item Fuct...
Power Apps
Unanswered

Choices This.item Fuctions not working for relationship fields

(0) ShareShare
ReportReport
Posted on by

Hi,

Im new to power apps.

I have my data in dataverse in two tables.

My main table is Documents that a have a relationship one to many with my other table "Providers"

 

1º Table, Documents Table:

FarmaVIP_0-1661779277579.png

 

2º Table Fornecedores( Providers) table:

FarmaVIP_1-1661779339159.png

 

 

I'm have 2 issues:

 

1- In the image bellow I'm trying to build a Gallery, my Data Source is my First Table (Documents table).

 

I'm trying to use  ThisItem.Fornecedores in Text property of a subtitle box in a image gallery but Is not working.

 

For normal columns it works because they are part of the main table, but  "Fornecedores" (providers) is column bind by a relationship coming from my second table, so it's not working.

What can I do?

 

FarmaVIP_3-1661779619195.png

 

 

2º Issue:

I'm trying to build a dropdown filter bind also bind to my Fornecedores field (Providers).

I'm using fuction Choices on items property and it works for the normal columns in my First Table. But the relationship Column (Fornecedores) shows the 4 options, but they're not appearing.

 

FarmaVIP_4-1661780096368.png

 

 

 

 

FarmaVIP_5-1661780166966.png

FarmaVIP_6-1661780284527.png

 

 

 

 

Categories:
I have the same question (0)
  • Verified answer
    AhmedSalih Profile Picture
    6,678 Moderator on at

    Hello, @FarmaVIP, let's start with issue no2:

    Change your Formula to: Choices(Documentos.Fornecedores).Name

     

    Then, Issue no1: ThisItem.Fornecedores.Name

     

     


    If my reply helped you, please give a 👍, & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


    I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


    Visit my Blog: www.powerplatformplace.com

     

     

     

  • FarmaVIP Profile Picture
    on at

    Thanks, it Works!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard