Power Platform Community Forum Thread Details

I am using powerapps with Common Data Service. I have Entity Team, which has got a Relotion Team <-> Utenti (many to many) with relation name teammembership_association and entity-relation name teammembership.
I want to use this relation in code (a ClearCollect) for enter in input a user and copy in the ClearCollect the records of Team.
How to do? Are possible any examples?
Thank

Categories:

Microsoft Dataverse with Power Apps

Hi @BlackRos ,

Could you please share a bit more about your scenario?

Could you please show more details about the ClearCollect(...) formula you used in your app?

Further, do you want to save the RelationShip data into a Collection or just use the Relationship to collct data from your two Entities?

If you want to save your RelationShip data ito a Collection, I afraid that there is no way to achieve your needs in PowerApps. There is also an known issue with Relationship (LookUp column) within PowerApps app -- when saving the LookUp field into a Collection, the LookUp field in the collection would not be populated with proper records.

If you want to use the Relationship to collct data from your two Entities, please check and see if the following article or blog would help in your scenario:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-relate-unrelate

https://powerapps.microsoft.com/en-us/blog/relate-records-in-many-to-many-relationships/

https://www.youtube.com/watch?v=X6PaYaC1iR4

https://www.youtube.com/watch?v=GJMpNj6-NXY

Best regards,