Since access web apps are going, we have to migrate our data to SP lists, (the recommended way).
So I see that powerapps can be used to make forms to get the data entry. But how can we make reports?
Is it possible to import word docs or text to make reports in powerapps? If so, we need to format reports in a4 to print with page breaks in the right places.
Or should we use power BI reports for this?
Thanks for advice
Could you please explain a bit for what kind of reports that you would like to create?
There are also Charts available in PowerApps:
For complex Reports, you may consider switch to Power BI.
Currently it is not available for PowerApps to import Word directly.
There is an idea submitted on this already:
@davetqmYou should use PowerBI for complex reporting like @v-micsh-msft says. Other option for light reporting is to use HTML Text. Please read https://powerapps.microsoft.com/en-us/blog/html-email-reporting-with-tabular-data/
There are two possible solutions for printing from Powerapps. The first is simpler but has some restrictions.
Create a report in Desktop access
MailMerge with Word
I hope this helps. I did this for data stored in CDS but it should work for Sharepoint lists as well. I am not sure if this is the most efficient way to do it but it worked for me.
Thanks, the mailmerge is what I need.
in your example with excel, in the last step. How do you connect a word mailmerge to an excel document in power bi? I can only see an option for browsing for a local file.
Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Continue your learning in our online communities.
Features releasing from October 2019 through March 2020
Coming to a city near you
Fill out a quick form to claim your user group badge now!
Connect, share, and learn with your peers year-round
Register by September 5 to save $200