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

Question

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.

Screen_Shot_1.JPG

Action_tool_Configuration.jpg

apathetichell · Answer

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.

Rvelan12 · Answer

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 · Answer

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.