ForAll with 2 Galleries to pivot a sharepoint list

(1) Share

Report

Posted on by polo1604

160

Dear all,

I'm builing an app which should show if my drivers have made their daily report or not. A kind of pivot table, in other words.

The data to be analyzed comes from a sharepoint list, with driver ID, date, and information about the daily work.

The screen to display the reports yes/no looks like this:

I wanted to create a table or gallery for each driver in the row and each date in columns with yes/no or 1/0 or whatever to visualize the result. I tried with countrows after filtering my sharepoint list, but it seems that "double" ForAll is not possible?

Thanks a lot for your ideas or suggestions.

best regards

Paul

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

narayan225 2,547 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@polo1604

What are the lists that you are using and the columns and the data type that you have set up in SharePoint?

Also, what formula are you trying to get this sorted?

Cheers!
polo1604 160 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @narayan225

the sharepoint list has following columns

DriverName: single text
ReportDate: date
other columns with text information

I want to group the list items at driver level, and show a table with yes/no in each column of my screen, matching with the date. So if there is a data entry in the sharepoint list with the same date then "yes" and if no data entry at this date, then "no".

I hope this is understandable

Thanks for your help !
Paul
narayan225 2,547 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@polo1604

You can do this on PowerBI.
Hope this helps.
Cheers!
polo1604 160 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @narayan225

and how could I achieve this ?

best regards
Paul
Verified answer

narayan225 2,547 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@polo1604
Open PowerBi Desktop and then select SharePoint as your data source.
After that, you can transform your data. I suggest you change the data type of date column to text.
After that, you simply need to add matrix and select Drivers as rows and the Date as column and then Date as values.
It should be all good after that.
After you have made the report, you can save it publish it and if you need, you can also add it to canvas app.
https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/how-to/build-powerbi-visual

Hope this helps.

Cheers!
polo1604 160 on at

Like
a
(1)

Report
Copy link

Link copied!

hi @narayan225
Power BI report is done, thanks a lot for your help.
I cannot publish it to a powerapps canvas, will have to investigate why..
best regards
Paul