cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JasonF
Level: Powered On

Using Lookups (relationship fields) in Charts

In the example below I have a Master table (Divisions) in the one to many relations with Sales. Using the "Division Name" as the relationship/lookup. However if I wasnt to chart all sales by "Division Name" it does not appear to be a selection on Chart Properties. Can this be done programically?

Chart2.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
JasonF
Level: Powered On

Re: Using Lookups (relationship fields) in Charts

Well  I did figure out a work around. If you create a collection, then add a column to that comlection and insert the text of the lookup into it.

ClearCollect( CompanyCollect, AddColumns(CompanyNameCollect, "Company", crdf5_DivisionName.'Division Name'))

Awkward, but it works.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Using Lookups (relationship fields) in Charts

Hi @JasonF ,

 

I think this cannot be achieved so far. Consider to add an idea in below forum if you need this feature.

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JasonF
Level: Powered On

Re: Using Lookups (relationship fields) in Charts

Well  I did figure out a work around. If you create a collection, then add a column to that comlection and insert the text of the lookup into it.

ClearCollect( CompanyCollect, AddColumns(CompanyNameCollect, "Company", crdf5_DivisionName.'Division Name'))

Awkward, but it works.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 342 members 5,925 guests
Please welcome our newest community members: