cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tianaranjo
Continued Contributor
Continued Contributor

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
v-xida-msft
Community Support
Community Support

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
Continued Contributor
Continued Contributor

@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!

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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (38,600)