We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to configure the File Browse tool's Action tool with SharePoint Input tool?

Rvelan12
7 - Meteor

Hi Alteryx Experts,

 

I have an Input Data(12) tool and SharePoint Input(4) tool on the Canvas. Both have 2 rows of data.

Both are connected to File Browse tool through Action tools as in the attached screen shot.

 

When I Choose a new File(Has 6 rows of data) and pass it through the Interface, Action tool replaces the existing File in the Input Data(12) tool and output Data(15) generated with 6 rows.

 

But not replacing the existing File in the SharePoint(4) tool and output Data(9) generated with 2 rows only.

I need to get the same output with 6 rows of data.

 

What configuration do I need to change in the Action tool which is connected to SharePoint Input(4) tool to get those 6 rows from the file.

 

I shared the Action tool configuration here.

 

Please advise me on this.

 

6 REPLIES 6
OTrieger
14 - Magnetar

@Rvelan12 
Why are you connecting the same File Browse tool to both Data input tool and the SharePoint Input? 

Rvelan12
7 - Meteor

Original  App has the Data Input tool which need to be replaced with SharePoint Input. Client moves the file location from Network drive to Sharepoint location.

 

That's why I have been testing the SharePoiint Input tool with the File Browse tool.

OTrieger
14 - Magnetar

@Rvelan12 
The File Browse tool is defining the path to the file, so if you connecting the same File Browse tool to the SharePoint Input you will not connect it to the correct path.

apathetichell
20 - Arcturus

I'm 90% sure that you need to use multiple action tools to modify multiple parts of the sharepoint tool - with multiple different values to get this to work.

 

see the ItemName - Value row -> that ALSO has to be updated via an action tool - and it has to conform to the expected value format. You may need to use a regex formula or some other formula to extract that from the full path. Are there other fields you need to edit? probably.

Rvelan12
7 - Meteor

I do not want to use multiple Action tools in my workflow. I need only One Action tool only.

 

But the File which I choose from the File Browse should replace the SharePoint Input's template file.

 

Still, I am not able to resolve this issue.

apathetichell
20 - Arcturus

I do not want to use multiple Action tools in my workflow. I need only One Action tool only.

 

You seem to know what you need so go for it. Looking forward to seeing how you solve it.

Labels
Top Solution Authors