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 / Choice function receiv...
Power Apps
Unanswered

Choice function receiving NxN relationship

(0) ShareShare
ReportReport
Posted on by 188

I have the table tbl_risco and tbl_tipo_de_risco in the Dataverse and they have a Many-To-Many relationship.

 

1.png

 

I'm on the Risk screen (tbl_risco) and I need to bring in a Choice function what is in the tbl_tipo_de_risco .

 

2.png

 

The card is as follows:

 

3.png

 

The field looks like this:

 

4.png

 

I've already tried to put some paths in the Choice field for testing and nothing worked, it gives the following message:

 

Translation from pt-br to en: "The specified column is read-only and cannot be modified"Translation from pt-br to en: "The specified column is read-only and cannot be modified"In the images above I left with the initial configuration for new tests.

I have the same question (0)
  • Verified answer
    Akash17 Profile Picture
    549 Super User 2024 Season 1 on at

    Hi @Deivid 

    Hope you are doing good!

    Please refer this

    https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-relate-unrelate

    Thanks

     

  • Deivid Profile Picture
    188 on at

    Hi @Akash17 

     

    This seems to be the path I have to follow, but it's still complicated.

     

    In the documentation it says:

     

    "These functions never create or delete a record. They only link or unlink two records that already exist."

     

    On the tbl_risco screen I want to be able to select what is in a Choice that would come from tbl_tipo_de_risco and then click on the Save button. Is the documentation already stating that this is not possible or did I understand it wrong?

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 840 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 332 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 275

Last 30 days Overall leaderboard