Issue with SharePoint Input Tool – Action Tool Replacing Value but Still Reading Old File

[Rihanmohamed]

I'm encountering an issue while working with the SharePoint Input tool in Alteryx Designer.

Here's the setup:

• I have a SharePoint folder structure where multiple engagements exist.

• Each engagement folder (e.g., 112015, 112016, etc.) contains a file named test.csv located at:
  Test  EngagementID Extractions/test.csv
  

My goal is to dynamically update the Engagement ID using the Action Tool so that the workflow picks up the file from the correct folder.

For example, I want to switch from:
Test/112015/Extractions/test.csv
to:
Test/112016/Extractions/test.csv

Issue:
Although the Action Tool updates the Engagement ID in the path correctly (visible in the updated text input), the SharePoint Input tool still reads the file from the original folder (112015). It’s as if the SharePoint Input tool is not recognizing or applying the updated path.

I've attached a screenshot for reference.

Has anyone experienced something similar or found a workaround to make the SharePoint Input tool pick up the dynamically updated path?

Thanks in advance for your help!

[ps_bradshaw]

Hi @Rihanmohamed,

I recently came across a similar problem and I think I have figured it out.  I was using the "Update Value" option to dynamically change the file name for the field "ItemName" and it was not updating the SP tool.  I found that the ItemName-value field was updating, but the Path-value remained with the default value as selected in the configuration of the SP tool.  Here is the xml.. you can see that the name updated to 202503, but the file path remained 202502:

</ItemPath>
<Path>Files for BI Team/Org 202502.xlsx</Path>
<DownloadURI>
</DownloadURI>
<ItemId>01CLXBTGN6Y2GOVW7725BZO354PWSELRRZ</ItemId>
<ItemName>Org 202503.xlsx</ItemName>

To fix, just add another action tool after your text box interface and have it update the specific string you want in the "Path-value" field.  That way, both get updated to the new value.  Screenshot shows how I set it up, can't show you the config pane because it has some credentials.  

Since you are dealing with the folder name change and not file name change, you may need to have the second action tool update the value of the "DriverName-value", as that looks like where the folder name is also.  Additionally, you also may need to do something with the "DriveValue - value" and "DriveId - value" fields using other action and interface tools as they may change based on the folder.  With that added complexity, you may be better off adding the differentiator in the file name within the same folder.