Forum Discussion

Naligurtan's avatar
Naligurtan
Brass Contributor
Nov 16, 2022

SharePoint Calculated filed in a list

Hello All,

 

I have a SharePoint Online list which has the following fields.

 

Event Title, Event start date(date), Event End date(date) and Event Confirmed(Yes/No) filed and Conformation date(Calculated filed).

 

An user inputs the following data/fields:

Event Title, Event start date(date), Event End date(date)

Manager comes and Select  the "Yes" option in the Event Confirmed(Yes/No) filed later.

I need this calculated filed "Conformation date(Calculated filed) to be completed/populated automatically with the same date when the manager select "Yes" in the "Event Confirmed" filed.

If it is not possible with a calculated filed, it might be possible with power automate/flow.

Looking forward to your supports.

 

Thanks in advanced.

Lists
SharePoint Online

1 Reply

  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Nov 17, 2022

    Naligurtan You can do this with power automate flow.

    1. Create a power automate flow which will run on item creation/update (based on your requirements)
    2. You can add trigger conditions so that your will not run always or update the date field again and again. Add trigger condition like: Event Confirmed equal to "Yes" AND Conformation date is blank
    3. Then use "update item" action to update the Conformation date field with current date using utcNow() function 

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.