Showing results for 
Search instead for 
Did you mean: 
Level: Power Up

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


Power Automate Community User Group Member Badge

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


Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!


Microsoft Learn

Learn how to build the business apps that you need.


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,886)