web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Append new row to Shar...

Power Automate

Unanswered

Append new row to SharePoint list

(0) Share

Report

Report

Posted on by Andy_2

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:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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

Join the conversation