cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Charliemacdmv
Helper I
Helper I

Work Orders to Bing Maps via when Excel file modified?

I manage a remote team. I had an idea but I'm not sure if it's possible. If I housed an excel sheet in SharePoint that contained a table for dispatch info.  Could I create a flow that when I update the excel sheet, it automatically gathers the data and exports all of it onto a Bing map via email? Basically so I could see where all of the dispatches are. A visual representation. 

 

So the end result would be an email with a map showing all the dispatches.

 

Thanks!!

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User II
Super User II

Hi @Charliemacdmv,

 

It might be possible via Power Automate. But personally I would try Power BI first.

 

I would import the excel file as a dataset and create a Power BI report:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks

 

You can also subscribe to Power BI reports via e-mail and sending it as pdf attachment is now even possible:

https://powerbi.microsoft.com/en-us/blog/full-report-attachment-for-subscriptions-for-power-bi-premi...

 

Hope this helps a bit?

View solution in original post

1 REPLY 1
Expiscornovus
Super User II
Super User II

Hi @Charliemacdmv,

 

It might be possible via Power Automate. But personally I would try Power BI first.

 

I would import the excel file as a dataset and create a Power BI report:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks

 

You can also subscribe to Power BI reports via e-mail and sending it as pdf attachment is now even possible:

https://powerbi.microsoft.com/en-us/blog/full-report-attachment-for-subscriptions-for-power-bi-premi...

 

Hope this helps a bit?

View solution in original post

Helpful resources

Announcements
MPA 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

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (19,484)