Power automate could be your option- when an item is created , use initial variable select the columns with- between them and use share point ID. gives you a Miquelon reference number. Try this link https://www.google.co.uk/search?q=power+automate+unique+reference&ie=UTF-8&oe=UTF-8&hl=en-gb&client=safari#fpstate=ive&vld=cid:88d24820,vid:vX8Vf06AH_o,st:220

Did you ever find out?

But I have a problem.. If i select start date as 16 and end date as 16 if i am taking full day leave, the total days should be 1 but it shows 0 in my case..

My question is can i add two formulas in 1 column, like if TRUE then +0.5 and if FALSE then +1…. that will work wonders if i can do that.

Thank you in advance.

Looking to create an automated column showing the year , taken from the ‘Date’ column. Hoping to keep the calculated year column as null when the ‘Date’ is blank. Not having 30/12/1899.

Could anyone please show me what I would need to change?

=IFBLANK(Date),””;TEXT(Date,”yyyy”)

I’m using sharepoint 2013 and sharepoint designer 2013 and infopath designer and filler 2013.

I have calculated fields that are populating values post submitting the report. I heard that there is no way to preview the results of calculated columns using the 2013 version of above applications mentioned.

I want to know if we have any options to use Lastsubmit() function in Info-path or sharepoint designer like we use in PowerApps.

Thanks!