SharePoint connection to read Excel file

[MadiNissi]

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.

[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 · Accepted solution]

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