How to connect MS Excel to ActivePieces

Need help
1

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!
2

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.
    image
    image1226×182 7.55 KB

Let me know if you face any errors.

Thanks,
Kishan

1 Like
3

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?

4

@Houefa ,

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

5

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

1 Like
6

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

7

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

8

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

9

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.

10

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