Can you change the filename when saving to Sharepoint Library?

[craigja]

I need to save an Excel file to a SharePoint Library, I want to prefix the filename with the month name but in the SharePoint tool I dont see an option to select a filename from a field or anything, the only option seems to be to specify the filename - is there a way to change the filename dynamically to have the current month and year?

[abacon]

@craigja I don't see an option. Have you tried to use Power Automate to do this and have alteryx trigger the power automate flow? I have found that to be a good tool when I run into the Alteryx/SharePoint limitations.

[craigja]

Nope - but thats a good shout!

[abacon]

@craigja give it a try, I just did a use case where I used Power Automate to send data from a SharePoint file to a SQL DB and then I hit that DB with alteryx - all in on workflow, very handy to have.

If it works for you, please mark it as the solution so others may find it sooner.

abacon