Unanswered

Error on creating/editing chart for model driven

(0) Share

Report

Posted on by NurNina

375

Hi, I have created a view for an entity called Yearly data. For that view, Ive added another field by linking to another entity to get the value using XrmToolBox. Below is the result:

errrroorrrrr 2.JPG

acc Country and aa Region(AFI) are the new fields. After i've published the new view, I've encountered a problem with opening charts for that entity (Yearly data). Below is the screenshot of the error:

does anybody know what's the issue and how to resolve it? Much appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @NurNina ,

How do you added "acct Country" and "aa Region(AFI)" field to the Yearly data View? Using XrmToolBox?

Regarding the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. The new fields added to your CDS Entity is subject to the "LookUp" relationship (Many-to-One).

You could add new fields to your existing View from related Entities through CDS in your PowerApps directly without using XrmToolBox:

Then click "Save" and "Publish", then re launch your Model Driven app again, the new added field would be shown up as below:

Please try above solution, then check if the issue is solved.

Also please consider remove the Chart from your CDS Entity, then re-create a new one based on the CDS Entity View, then check if the issue is fixed.

Regards,

Was this reply helpful? Yes No
NurNina 375 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xida-msft Ive tried using the related field inside the view. However, the data is not showing. like the country below:

But when I link the entity using fetchxml, the are data inside the related field :
here is the xml:

I link the yearly data to account to get the country. and then from country,im trying to get the region.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @NurNina ,

Regarding the fetchxml formula that you mentioned, I find that you want to display In-Direct related column data in your Entity View, right?

If you want to display In-direct related column data from other Entities in your Entity View, I afraid that there is no way to achieve your needs. You could display the data using fetchxml query in your XrmToolBox, but it could not be supported in Entity View currently.

Currently, within Entity View, you could only display direct related column data from other Entity through the "Many-to-One" relationship, you could not display Indirect Related column data from other Entities in Entity View.

Regards,

Was this reply helpful? Yes No
NurNina 375 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xida-msft thank you for the help but I wonder why there is no data shown when Im using the related field for Entity view like the country in the image above?

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @NurNina ,

Please make sure you have related the records in your Main Entity to records in your Account Entity through the "Many-to-One" relationship.

If you do not related the records from your Main Entity to records in your Account Entity through the "Many-to-One" relationship, when you add the related field in your View, it would display blank.

Please check and see if the following article would help in your scenario:

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

Regards,

Was this reply helpful? Yes No
NurNina 375 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xida-msft ,
the Main entity is related to Account entity.

and there are accounts inside yearly data:

but Im wondering why I still cannot get the related field of country from account.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @NurNina ,

Currently, I could not reproduce your issue on my side. Have you tried to remove the Entity View from your Main Entity, and then re-create a new View for your Main Entity, then try it again, check if the issue is solved.

If the issue still exists, please consider submit an assisted support ticket through the following link:
https://powerapps.microsoft.com/en-us/support/pro

Regards,

Was this reply helpful? Yes No