cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Magikmissy
Level: Powered On

Smartsheet connection broken

I'm new to Flows but want to use a template that will allow me to use an 'input form' (in MS Forms) which will then update Smartsheet. There was a link to let me make the connection to MS Forms and to Smartsheet but the Smartsheet one didn't work. Can anyone help me at all please? 

scrn2.jpg

scrn.jpg

6 REPLIES 6
Super User
Super User

Re: Smartsheet connection broken

Hi @Magikmissy 

 

You're doing the right steps to do the connection. There is an issue between Smartsheet and Power Automate. I think this can be:

  1. A temporary issue in the connection or service
  2. Don't have permission on the Smartsheet side to add a connection to Flow.

 

Can you ping the guys over at Smartsheet to see if there's an issue from their side and check the permissions?

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Community Support Team
Community Support Team

Re: Smartsheet connection broken

 

Hi @Magikmissy ,

 

  • First, you need to make sure that the account you use to create Smartsheet connection can log in to Smartsheet.
  • Then you can try to clear your browser cache and create a new connection again.

Please take a try and see if the issue still exists.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Magikmissy
Level: Powered On

Re: Smartsheet connection broken

Hi @v-bacao-msft

Thanks for this. I use Smartsheet all day every day so there's no issues there, and I just cleared my browser cache but it still didn't work. 

😫

Highlighted
Magikmissy
Level: Powered On

Re: Smartsheet connection broken

Hi @manuelstgomes

Thanks for your response. The people at Smartsheet say it's Microsoft's issue and vice versa!! 

🙈

Super User
Super User

Re: Smartsheet connection broken

Hi @Magikmissy 

 

I don't know Smartsheet, but is there an administrator or similar role that you need to define so that you can link Power Automate with Smartsheet? 

 

I just created a trial account and did the following steps.

  1. Logged in my account in smartsheet
  2. Create a new Flow
  3. Added the trigger "When a new row is created"
  4. Clicked the add connection
  5. Prompted me with the permissions:

Screenshot 2020-01-27 at 11.26.56.pngand then I got the connection working:

Screenshot 2020-01-27 at 11.27.06.png

 

Then I went digging and found the user management page:

Screenshot 2020-01-27 at 11.30.04.png

 

I suspect that your user doesn't have permission to do "admin" tasks like approve connections and allow access.

 

Can you please check with your Smartsheet admin if you have any of these permissions so that you can add the connection in Flow?

 

I hope this helps.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Magikmissy
Level: Powered On

Re: Smartsheet connection broken

Thanks @manuelstgomes but I have admin rights on both bits of software. 😏

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users online (5,107)