I'd like to get my head around some basic reporting within the PowerApp I'm building.
The App itself is a staff database around staff development.
I have some fields within the PowerApp that I would like to have a Dashboard style page report on.
The first two being:
Each staff record has an 'Active' drop down field that has Yes / No option. My first two would be How many Active Staff do we have & How many Inactive staff do we have and report back a figure like the picture below.
When a user selects; for example, 'Total Active Staff', I want this to navigate to a new window & gallery to show those results.
oh and a shout out to @WarrenBelz for taking the time out of his evening and helping me solve a problem that was sending me to an early grave!
Solved! Go to Solution.
Ah, so you are using the same variable in other places with dissimilar record schemas. Where else are you trying to set glbCurrentRecord? It should ONLY be set on the DashBoard Gallery OnSelect.
I have fixed:
& added the little bonus you gave me of: glbCurrentRecord.Title & " Report"
The only problem that still exists is that my current Detail Screen and Edit Screen use BrowseGallery1 which was the original app gallery made by PowerApps.
When I navigate from Dashboard to Dashboard Report Gallery and then from there to use the original Detail and Edit screens?
Yes, so those editforms should have an Item property based on the Gallery you are selecting from - your Dashboard Report Gallery.
I believe that was Gallery2 - so, Gallery2.Selected
Currently the Detail and Edit form have the Item of BrowseGallery1.Selected which is the original gallery.
Is there a way of having BrowseGallery1 and Gallery2 . selected??
I explained that it would be set to the glbCurrentRecord variable. You would only be setting this variable with the same record type as your datasource and then your Detail and Edit form would use that variable on the Item property.
Is there any issue with getting that to work?
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.