SharePoint connection to read Excel file

Hi Experts,

I am using SharePoint connection tool to get the data from an Excel file. In the Browse tool I can see the data (columns and rows) but when I connect to a Formula tool there is no Output column to select.

Am I missing an step here?

I have this current workflow running well but the input data in from OneDrive.

Appreciate your help!

Thank you.

Correct.png

Incorrect.png

Tips and Tricks

Connectors

Preparation

Sharepoint

Accepted answers

MadiNissi

Hi Alex,

I built a new workflow from the scratch and now is working fine and I am getting the fields to be used in Formula tool.

Also, I had an issue with the output data in SharePoint and after running 3 times the error did not happen anymore. I am doubting if this it was a problem with SharePoint connection.

Many thanks for you quick r

All comments

alexnajm

Run the workflow and you should see fields populate!

MadiNissi

Hi Alex,

I ran the workflow but the fields did not populate which is odd.

alexnajm

Can you show us that? Click on the anchor before the Formula after you've run the workflow and grab a screenshot of the whole screen (the results data, the Formula config, etc.)

You can also try caching your SharePoint Input tool by right clicking on it and clicking Cache Workflow. Also is your "Disable Autoconfig" turned off in the user settings (should be turned on)?

MadiNissi

Hi Alex,

I built a new workflow from the scratch and now is working fine and I am getting the fields to be used in Formula tool.

Also, I had an issue with the output data in SharePoint and after running 3 times the error did not happen anymore. I am doubting if this it was a problem with SharePoint connection.

Many thanks for you quick r

alexnajm

Ok happy to hear it! Go ahead and mark one or multiple responses as a solution to close out this thread

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703