SharePoint to Smartsheet Integration Using Power Automate
Let me start by acknowledging that I am a complete API/Power Automate novice. However, I am trying to create an automated method to trigger my Smartsheet workflow when my client posts a document to a SharePoint folder (serving as a central repository). After some preliminary research, it appears that Power Automate may be the leading option.Does anyone have experience with this scenario?
When i got into Power Automate, it appears I could create a flow triggering from the creation/modification of a document in a designated SharePoint folder. Then I could configure a connection with Smartsheet...as the destination end. When i did that, it asked for the Smartsheet sheet number to direct it to a specified sheet, as well as some other information. This is where I was way over my head expertise-wise. So I didn't get this to work, but it seems as though it should. I have a SharePoint resource that is willing to work with me, but I am looking for a little more direction. Can anyone help me out here?