Need Power Automate to generate a sequence number as part of each entry in sharepoint

(0) Share

Report

Posted on by PowerUser007

Hi All,

I am quite new to Power Automate, so please bear with me.

I have created a flow which create a sharepoint record entry everytime an email(with specific subject) is received in my outlook.

My requirement is to create a sequence number in sharepoint with each addition.

Is that possible?If yes, then how.

Thankyou in advance for the help.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (1)

Report

Hello @PowerUser007,

in a SharePoint list there's an already existing column name "ID" that represents the unique number for each created item.

Are you referring to that column?

Please let me know if the issue is fixed.

If I have answered your question, please mark my post as Solved.

If you like my response, please give it a Thumbs Up.

I may not have all the answers, but I'm curious and passionate enough to keep looking for answers and to keep sharing them.

My blog site about Power Automate: https://powerautomatejoy.com/

BR,

Marco

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Hello @PowerUser007 ,

is the issue fixed?

BR,

Marco

Was this reply helpful? Yes No
PowerUser007 8 on at

Like (1)

Report

Not yet. And it is not the ID column. I will create a single line text column which should have sequence number in it to track the number of entries

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (1)

Report
Hi @PowerUser007 ,

What rules do you want these serial numbers to be generated?

If you want to generate a non-repeating sequence number, you can try :

formatDateTime(utcNow(),'yyyyMMddHHmmss')

Best Regards,

Bof

Was this reply helpful? Yes No
PowerUser007 8 on at

Like (0)

Report

Sequence number should be +1 from the last entry of the sharepoint.

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @PowerUser007 ,

You could try:

1\list all items and order by the 'sequence number' column

2\get the first function to get the first item's 'sequence number' to get the greatest 'sequence number'.

3\Use the int function to convert the 'sequence number' to int number.

4\use the add function to do +1 to get the new 'sequence number'

Best Regards,

Bof

Was this reply helpful? Yes No
PowerUser007 8 on at

Like (0)

Report

Thanks.
Where in the flow this has to be accomodated?
My flow looks like this:

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @PowerUser007 ,

You could insert the action here.

Best Regards,

Bof

Was this reply helpful? Yes No