New excel file to be created every month on SharePoint and updated daily.

(0) Share

Report

Posted on by AdyG

Hi,

I have created a flow wherein a new excel file gets created on SharePoint, every time the flow is run.

The file name being 'Output_Jan_2024' and once the file has been created, the next time flow will only update the file, till Jan ends.

At the start of next month, a new file has to be created('Output_Feb_2024') and same file gets updated till Feb ends and so on.

I have created the below flow so far:

Recurrence: scheduled to run daily
File Content: ‘Compose’ action to capture the output of a new excel file.
Create File: gets the output of ‘File content’ to create an excel file.

Create Table: Format as table

What action do I need to add to capture, if the folder already has the current month file, update the same file, else create a new?

Thanks.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

v-jefferni on at

Like (0)

Report
Hi @AdyG ,

You need a Condition control to judge if there is current month file in SP library. To achieve this, you need a Get files properties only action, then a Condition control following it. You can use Filter query in Get files action to get current month files based on file names:

substringof(Output_formatDateTime(...), 'FileLeafRef')

and then in Condition, checking the number of files get from above action:

length(body('Get_files_(properties_only)')) is greater than 0

if yes, add a row into table, if no, create file, create table then add a row into this table.

Best regards,

Was this reply helpful? Yes No
AdyG 50 on at

Like (0)

Report

Hi @v-jefferni,
The 'substringof()' function is not working, it gives the below error:

Also could you please help with the 'FileLeafRef', is this a column or property available on SharePoint?

Thanks.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @AdyG ,

Sorry, single quotes are not needed for FileLeafRef in filter query:

FileLeafRef represents the Name column in SP library, just be used in filter query.

Best regards,

Was this reply helpful? Yes No