Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Calculated Column base...
Power Automate - Building Flows
Unanswered

Calculated Column based on Different List Inputs

(0) ShareShare
ReportReport
Posted on by D_G_D 2

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...

 

Image

Categories:
Business Process Flows
  • D_G_D Profile Picture
    D_G_D 2 on at
    Calculated Column based on Different List Inputs
    @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. 
  • RobElliott Profile Picture
    RobElliott 10,155 Super User 2025 Season 1 on at
    Calculated Column based on Different List Inputs
    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.
  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,778 Super User 2025 Season 1 on at
    Calculated Column based on Different List Inputs
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans