Hi everyone! I have a bunch of reports in access and I'm looking to transfer them over to PowerApp. I see a lot of data reports that basically look like spreadsheets, but is it possible to create something that looks more like a manning report (like below)? It needs to have automatic headers that can be sorted and grouped and easily pulled just like a MS Access report.
Thanks!
Jen
Hello @Jen_kur
I found a similar community post that I believe might help with your query :
How to connect PowerApps with local MS Access 2016... - Power Platform Community (microsoft.com)
As another alternative, since there is no connector for these two apps, I would suggest that you export your data from the report to an excel file. And use it as data source for a form in power apps and it should create automatic headers and organize the information.
I linked a few articles I think might help:
Understand canvas-app forms - Power Apps | Microsoft Docs
Format a table in Excel and naming tips - Power Apps | Microsoft Docs
Best Regards,
Diana
WarrenBelz
146,635
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,997
Most Valuable Professional