How to connect MS Excel to ActivePieces

Dear community,
I would like to connect my MS365 account to Activepieces with Excel.
I created an app in Azure, and then I entered the information in Activepieces:

  • For the Client ID : I enter the Application ID (Client)
  • For the Client Secret : I created a secret key and I enter the Secret ID.
    When I validate, I have the error message saying: “Connection failed, make sure client id and secret is correct.”.
    Can someone help me to fix this problem?
    Thanks in advance for your help!

Hello @Houefa , Welcome to the community :wave:,

Please ensure that you have completed these steps to set up authentication for your MS365 Excel piece:

  1. Add https://cloud.activepieces.com/redirect in Redirect URIs of Azure app.
  2. Instead of the Secret ID, copy the Value for the Client Secret. Please refer to the attached image for clarification.

Let me know if you face any errors.

Thanks,
Kishan

1 Like

Hello @kishanprmr !

Thank you for your help. Now it works, I could connect Activepieces and MS365.

I have another problem where Activepieces shows an error message when I want to select my workbook:
Capture d’écran 2024-03-18 à 15.51.57
Shoud I do something else to connect my workbook?

@Houefa ,

Can you try refreshing the page and see if that woks?

I still have the error message. I tried to reconnect the app and the message remains.

1 Like

The same to me. Connected to MS 365 but I can not use it.
(I have shared the error: Error connecting to Microsoft Excel )

It works ok now.
Very good.
I like ActivePices very much.

What did you do to be able to connect MS36? I still have an error message.
Thank you

I am using Personal Office 365 (paid plan), set up ID/Secret key as you said at the #1. Connect OK. and now Activepieces can scan all file excel. I have check triggers, Test data…

Successful.

Please re-connect and check. I think your connect to MS Excel 365 works OK today.

PS: I have check update at https://www.activepieces.com/pieces, and try again.

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.