gravity

[jeroenderooij]

I am trying to setup Gravityforms with Excel (office 365). Gravityforms goes perfect.
I can also connect to excel (office 365), but can't connect the headers in the sheet with the input of gravity.
Worksheet is test, but then i only get one column so it looks.
What is going wrong?
Thank you
Jeroen

 

[Preeti Paryani]

Hello @jeroenderooij,

Please follow the steps mentioned in the attached thread and let us know if they help you populate columns of your Excel sheet.

Steps to be followed to access the Workbooks in Microsoft Excel.

Please follow the exact steps below and let us know if this helps in displaying the worksheets and workbooks in the dropdowns: Log in to OneDrive. Instead of opening the Excel file directly, search for Excel files by entering "xlsx" in the search bar. Click on the required .xlsx file to open...

forum.pabbly.com

 

[jeroenderooij]

Hello Preeti Paryani,
Thank you for your help, i can see the workbooks, but i can't see the excel column headers, to connect the gravity fields to.
And i am connecting to the online excel in sharepoint.
Thank you
Jeroen

 

[Preeti Paryani]

Hello @jeroenderooij,

Apologies for the oversight. Please note that for the Excel integration, we currently support only Excel files stored in OneDrive. Excel files stored in SharePoint are not supported at the moment.

 

[jeroenderooij]

Hello Preeti,
Thank you, i tried to connect and now see one column with this error:

Column {{$Root.CellAddresses[0][This.Key].Replace(/[0-9]/G, '')}} ({{This.Value?This.Value:'< Empty> Header'}})

What could go wrong here?
Thank you
Jeroen

 

[jeroenderooij]

Hello Preeti,
I just tried to connect it through the 'classic' version and than it works correct. Maybe it has something to do with the new workflow builder?
Thank you
Jeroen

 

[Preeti Paryani]

Hello @jeroenderooij,

Thank you for the update. Please note that in your case the Excel columns are being rendered from the Excel file stored in your SharePoint account. Since SharePoint is not officially supported, we cannot guarantee whether it will continue to work consistently. That said, if it is working fine for you now, that’s great to hear.

Wishing you a smooth experience ahead.