web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Chart from a gallery o...

Power Apps

Answered

Chart from a gallery or collection from two data sources

(0) Share

Report

Report

Posted on by Manarjomar

248

Hi all,

I want show a Chart that is using diferent sources but all data are together in a Collection.

The chart must to show:

Categorie (grouped and sorted by it)

MaxHours

MissingHours

The problem is that MaxHours is from a plant table and MissingHours is from breakdowns table, but both have the Categorie field.

As I said, I have a gallery and collection because I use it to show a report in HTML (this works perfect), but I can't use it to show the Chart:

any idea?

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Manarjomar 248 on at

Like (0)

Report
Copy link

Link copied!
I did it!!

Well, finally I did it using two steps:

My original collection is "Equipos" (with all nested records). Know that I have a button to create a new collection "Grafico" using "Equipos":

Clear(Grafico);; ForAll( Equipos; Collect( Grafico; {Categoria: Categoria.Text; HorasMáximas: HorasMaximas.Text; HorasPerdidas: HorasPerdidas.Text } ) )

Later, the item propetie on the chart is:

AddColumns( GroupBy( Grafico; "Categoria"; "Grupo" ); "QHM"; Sum( Grupo; HorasMáximas); "QHP"; Sum( Grupo; HorasPerdidas) )

Maybe is possible do it easier but I don't know... hehehehe.

Any way, is here to help.

Now I have a new task to do it with the chart. But I will open a new topic.

Thank you to read.

Was this reply helpful? Yes No

Join the conversation