Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Answered

How do I add a report to a solution or create a new system report in Power Apps?

(0) ShareShare
ReportReport
Posted on by 180

Hi All,

In the old interface for customisation, I was able to create a report in the default or a new solution which I could then export and import into a different crm environment.

I can't see anywhere in the new PowerApps interface where I can do this. 

I've read some partially conflicting advice on the ability to include reports in a solution:

This article (https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/add-reporting-to-app) states "Reports are solution aware. Adding a report as a component to a solution makes it become a single unit of software that extends Power Apps functionality and the user interface. Only reports that are visible to the organization can be added to solutions."

But this article (https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/customize-organize-reports) states "In Dynamics 365 Customer Engagement (on-premises), reports are solution aware. Adding a report as a component to a solution makes it become a single unit of software that extends Dynamics 365 Customer Engagement (on-premises) functionality and the user interface. Only reports that are organization owned or visible to the organization can be added to solutions."

Can anyone provide any advice on if it is still possible to add a report to a solution, or if not, what's a good way to transport reports between environments (TEST to PROD etc)

Thanks,

Cameron.

  • Community member Profile Picture
    Community member 14 on at
    How do I add a report to a solution or create a new system report in Power Apps?
    Hi Cameron,
    As a Power Apps consultant, I've encountered similar challenges when transitioning reports between different CRM environments, especially with the updates in the PowerApps interface. It's important to note that while reports are solution aware, the process of adding and transporting them can vary based on your specific setup and the version you're working with.
    In my experience, ensuring that reports are organization owned and checking the compatibility with your target environment are crucial steps. Additionally, consider the data dependencies and custom entities involved in the reports. For a smooth transition, it might be helpful to use the Power Apps Solution Checker for identifying potential issues before moving from TEST to PROD.
    Hope this helps, and feel free to reach out if you have more specific queries or need further clarification!
    Best,
    Ivan Farafonov


  • CamParker Profile Picture
    CamParker 180 on at
    RE: How do I add a report to a solution or create a new system report in Power Apps?

    Hi Again Lu Hao!

    thanks for that info. It worked! I'm sure I tried all of this yesterday but couldn't see the reports I created in the list of reports I could add to a solution... not such issues today

  • Verified answer
    LuHao Profile Picture
    LuHao 40,872 on at
    RE: How do I add a report to a solution or create a new system report in Power Apps?

    Hi CamParker,

    Yes, there is really no reporting component in the PowerApps interface, so you cannot create system reports in it.

    But you can add a report to a solution.

    In the PowerApps interface, go to Solutions and open a custom solution.

    2134.pastedimage1581487237401v1.png

    Click Add existing > Report, select reports and add them. Finally publish all customizations. The report is added to the solution.

    1586.pastedimage1581487276234v2.png    3487.pastedimage1581487348047v3.png    4405.pastedimage1581487371713v4.png

    To create a system solution, you could do it through the OOTB report editor, without having to enter the new or old interface for customisation.

    Edit a report (you could edit it through Advanced Find), on the Administration tab, see if Viewable By is set to Organization. If it is Organization, then this report is a system report and can be added to the solution.

    1134.pastedimage1581487724219v6.png    8308.pastedimage1581487789561v7.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans