Sharepoint Input Link - Dynamic Reading

[pchong]

Hi Community,

I am trying to extract xlsx format data from SharePoint using SharePoint Input tool.

My objective is to replicate a Directory & Dynamic Input method for a more automated method to grab a specific/latest file from a folder everyday.

This is the macro created to update the link.

This is the workflow to dynamic read the specific file from the link (Filter tool here will extract only one entry/link to be feed into macro).

However, I did not get the desired output. The link was not updated.
I selected SiteUrl, SiteValue to be updated in the macro.

Not sure if I picked the wrong parameter or something wrong elsewhere.

Any advice is greatly appreciated.

Unfortunately, due to privacy issue, I am not able to share the workflow.

Thanks in advance!

[alexnajm]

Try this solution! Solved: Replicating Dynamic Input with SharePoint Files In... - Alteryx Community