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.
@Rvelan12
Why are you connecting the same File Browse tool to both Data input tool and the SharePoint Input?
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.
@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.
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.
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.
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.