Unanswered

Calculated Column based on Different List Inputs

(0) Share

Report

Posted on by D_G_D

I’m attempting to create a calculated column based on inputs from different list items, not different columns. As an example, the screenshot below has a Meeting Agendas “list” with times assigned to each item. If I change “Agenda 1” from 10:00 AM to 10:30 AM, I’d like “Agenda 2” to change from 10:30 AM to 11:00AM, and “Agenda 3” from 11:00 AM to 11:30 AM. Is this possible? While it’s clear you can create calculated columns based on different columns inputs, I’m trying to do this based on different list inputs. I'd also love to only have times displayed, not the date + time, but that's a separate issue...

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

I am not sure whether this can be via calculated column directly

May be it would be possible to do via power automate cloud flows.

Thanks & Regards,

Nived N

Was this reply helpful? Yes No
RobElliott 10,323 Super User 2025 Season 2 on at

Like (1)

Report

I'm not sure why you are so intent on using a calculated column. It won't work: a calculated column cannot iterate over different items in a list, it can only do a calculation based on columns in the current item. But it is possible to do this with a flow in Power Automate that checks if the Time column only) has changed. If it has then send an http request to SharePoint to get the previous value. Then calculate the difference in minutes between the previous time and the new time and then, for each agenda item for that date, increase the time in the Time Date/Time column by that number of minutes. It's quite a complex flow but do-able.

"I'd also love to only have times displayed, not the date + time". This isn't possible with a date/time column, it will always show the date.

Was this reply helpful? Yes No
D_G_D 2 on at

Like (0)

Report

@RobElliott I would't say "so intent". Not sure how you took that away from my post. I'm just simply asking if it's possible, which you at first say it isn't then say it is with a "complex" flow? I'm posting because I'd love for someone to help build the flow! Hence this post is in "Building Flows"....

It also seems that a quasi "time only" column is actually possible. In doing some searching on this forum after posting my question, there's simple code that can be used to export time only into a separate text column.

Was this reply helpful? Yes No