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.