Unanswered

Append new row to SharePoint list

(0) Share

Report

Posted on by Andy_2

I have a SharePoint list called A and a folder in SharePoint. Whenever a new file is added to the folder, I want to automatically add a new row to list A with the name of the Excel file. Additionally, I need to extract the last number from the file name, for example, if the file name is FirstFile_V002.xlsx, I need to extract '2'. If the file name is SecondFile_V011.xlsx, I need to extract '11'. Can you please guide me on how to achieve this using Power Automate? Thank you for your assistance

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

grantjenkins 11,063 Moderator on at

Like (0)

Report
Re: Append new row to SharePoint list

Assuming the filenames will always include Name then _V then a number, you can try the following.

For the trigger I would use When a file is created (properties only) and specify the folder you want to look at.

Then Create item using the File name with extension for Title and the following expression to get the number. It will get the name of the file (excluding the file extension), split on _V and get the last item, then convert to an integer (which will remove the leading zeros).

int(last(split(triggerOutputs()?['body/{Name}'], '_V')))

Was this reply helpful? Yes No
Andy_2 2 on at

Like (0)

Report

Re: Append new row to SharePoint list

Thank you a lot, I will check this. I have another question can I add new column to an existing list that have the max of : int(last(split(triggerOutputs()?['body/{Name}'], '_V')))
each time I aded new row to the list that column should be changed with the max value.

Was this reply helpful? Yes No