Showing results for 
Search instead for 
Did you mean: 
New Member

Connecting dynamics to google sheets

Hi - I am trying to build a flow where I take a Saved Opportunity View in MSdynamics and export its contents every night at 1am into google sheets.  
I used to be able to do this with salesforce using the Sheets add-ons.  Here, I could just use the connector and then select the report I wanted to export... but it looks like I need to use Flow with MSD.  


Now, I've managed to get it to find the google sheet, but I am struggling to get it to find the saved view in MSD to export.  I am using Get Record > Organisation name > Saved Views > [asks me for an item identifier].

How do I find out what the item identifier is for my saved opportunity view?   

I've also tried clicking on the 'add dynamic content' and it says it is empty.  


Any clues or the best resources to work out how to do this?


Helpful resources


Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!


Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,863)