You’re offline. This is a read only version of the page.
Announcements
4
I have 2 dataverse table - 'Actor' and 'Service' with '1-M' relationship.
Actor table:
| Name | Country |
| Act1 | Australia |
| Act2 | America |
Service Table
| Service | Country |
| Marketing | Australia |
| Advertising | America |
I load records of a country from 'Actor' in a collection 'colactor'. I want to have have another collection with related 'Service' in
colrelservice'. I have not been able to do it. I tried using ForAll as
clearcollect(colrelservice, ForAll(colactor, {Svc: colactor[@country].Service}) but it gives me an error column not available in context. I tried using filter as well but not able to make much progress.
Any assistance would be appreciated.
Hi , @Bhatti78
According to your description, you want to combine two tables in a collection? And the two tables is 1:M relationships.
For your need , you need to use the M table to get the data.This is my test data in Dataverse:
In Power Apps , you can use this code to test:
Share
Report
All responses (
Answers (
ClearCollect(data,ForAll('Service Tables' , {Service:cr667_service,Country:cr667_Country.Country,Name:cr667_Country.Name}));The result is as follows;You need to replace the real column Name in your side .
Best Regards,
Yueyun Zhang
