cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
tianaranjo
Level 8

Email Gantt from PowerApps or Excel

We would like to:

  1. Create a Gantt from PowerApp data 
  2. Email Gantt and data from PowerApp to a distribution list

Has anybody successfuly used a Flow to email a Gantt chart?

3 REPLIES 3
Community Support Team
Community Support Team

Re: Email Gantt from PowerApps or Excel

Hi @tianaranjo,

 

Could you please share a bit more about your scenario?

Do you want to create a Gantt within PowerApps?

 

For your first question, if you want to create a Gantt within PowerApps, I afraid that there is no way to achieve your needs in PowerApps currently.

 

If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

 

As an alternative solution, you could consider take a try to create a Gantt chart (tile) within Power BI dashboard, and then embeb the Power BI tile (Gantt chart) within PowerApps using Power BI tile control.

 

More details about embedding Power BI tile within PowerApps, please check the following the article:

Embed Power BI tile within PowerApps

 

More details about creating a Gantt chart within Power BI, please check the following blog:

https://ppm4all.com/2016/03/10/creating-a-gantt-chart-of-your-projects-tasks-and-resources-in-power-...

 

 

For your second question, if you want to send a Gannt chart from PowerApps to a distribution list via email, I afraid that there is no way to achieve your needs in PowerApps and Microsoft Flow.

 

As an alternative solution, you could consider take a try to subscribe the Distribution list to Power BI dashboard (or the report) which contains the Gannt chart.

 

More details about subscribing to a recport or a dashboard in Power BI, please check the following article:

https://docs.microsoft.com/en-us/power-bi/service-report-subscribe

 

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tianaranjo
Level 8

Re: Email Gantt from PowerApps or Excel

@v-xida-msftThank you for your thoughtful reply.  I nearly have this working utilizing an image control.  Where I am now stuck is emailing the image from the powerapp.  At this moment, I am trying how to get configure the image source as described  in this link:

 

https://powerusers.microsoft.com/t5/General-Discussion/How-to-add-an-image-in-a-HTML-table/m-p/10006...

 

I copied the image and pasted into OneNote - can you tell me if the source described in link above is contained in the Sessionid?  If so, what 'part' do I use in the formula?

 

Thank you!

Community Support Team
Community Support Team

Re: Email Gantt from PowerApps or Excel

Hi @tianaranjo,

 

Could you please share a bit more about the Image control that you mentioned within your app?

Could you please show more details about the formula wihtin the Image property of the Image control?

Further, do you want to embed the image within your OneNote?

 

I have made a test on my side, if you want to copy the image source described within the link that you provided into your OneNote, please take a try with the following workaround:

 

  • Create a connection to OneNote connector within your app.
  • Add two Drop down controls (Dropdown1, Dropdown2), and a Button control ("Upload" button) within the screen of your app.7.JPG

     

 

Set the Items property of the Dropdown1 control to following formula:

'OneNote(Business)'.GetNotebooks()

Set the Items property of the Dropdown2 control to following formula:

'OneNote(Business)'.GetSectionsInNotebook(Dropdown1.Selected.Key).value

Set the OnSelect property of the "Upload" button control to following formula:

'OneNote(Business)'.CreatePageInSection(
Dropdown1.Selected.Key,
Dropdown2.Selected.pagesUrl,
"<img src='https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTf8peeAQ8Jbw4lowjdYM9OYVJFJr8EwgGNTsJ6BtbqPdNHWz2m' alt='Red dot' />"
)

or

'OneNote(Business)'.CreatePageInSection(
Dropdown1.Selected.Key,
Dropdown2.Selected.pagesUrl,
"<img src='data&colon;image/png;base64, iVBORw0KGgoAAAANSUhEUgAAAAUAAAAFCAYAAACNbyblAAAAHElEQVQI12P4//8/w38GIAXDIBKE0DHxgljNBAAO    9TXL0Y4OHwAAAABJRU5ErkJggg==' />"
)

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 79 members 4,354 guests
Please welcome our newest community members: