SharePoint List conditional serial number

%3CLINGO-SUB%20id%3D%22lingo-sub-1495172%22%20slang%3D%22en-US%22%3ESharePoint%20List%20conditional%20serial%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1495172%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20appriictate%20if%20anyone%20helped%20me%20with%20a%20way%20to%20deal%20this%20conditional%20serail%20numbering%20(daily%20sl%20%23)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20SharePoint%20lists%2C%20I%20have%202%20columns.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1st%20column%20is%20a%20list%20of%20dates.%20there%20could%20be%20repeating%20of%20the%20same%20dates.%20The%202nd%20column%20is%20the%20serial%20number%20(for%20date)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEvery%20time%20date%20changes%20to%20new%20date%2C%20the%20serial%20%23%20resets%20to%201.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22cad-one_0-1593401388730.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201796i14144CE8C505D9EC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22cad-one_0-1593401388730.png%22%20alt%3D%22cad-one_0-1593401388730.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20of%20like%20daily%20serial%20numbers.%20Next%20days%2C%20the%20serial%20number%20need%20to%20restart%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1495172%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1495207%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20conditional%20serial%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1495207%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F712688%22%20target%3D%22_blank%22%3E%40cad-one%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20about%20using%20a%20Power%20Automate%20Flow%20for%20updating%20SOS%20Pre%203%20column%3F%3C%2FP%3E%3CP%3EFlow%20could%20be%20triggered%20when%20new%20item%20is%20added%20to%20a%20list%2C%20get%20count%20of%20list%20items%20filter%20by%20Received%20date%20and%20update%20SOS%20Pre%203%20column%20with%20count%20of%20returned%20list%20items.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi,

 

I would appriictate if anyone helped me with a way to deal this conditional serail numbering (daily sl #)

 

In SharePoint lists, I have 2 columns. 

 

1st column is a list of dates. there could be repeating of the same dates. The 2nd column is the serial number (for date)

 

Every time date changes to new date, the serial # resets to 1.

 

cad-one_0-1593401388730.png

 

Kind of like daily serial numbers. new date, the serial number need to restart again.

 

1 Reply
Highlighted

Hi @cad-one,

 

How about using a Power Automate Flow for updating SOS Pre 3 column?

Flow could be triggered when new item is added to a list, get count of list items filter by Received date and update SOS Pre 3 column with count of returned list items.