Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Power automate flow create item in another list strange behavior

(0) ShareShare
ReportReport
Posted on by 159

Hello,

I have a list with multiple columns and a calculated column . This column  (Column Name-Data nasterii ) calculate automate birthday based on Card ID stored in other column. This calculated column is date formatted. After an item is created in this list i copy this item to another list using flow. The calculated column is copied in the new list but always display the Birthday date minus 1. I don't know why and  try to figure out a solution. Also in the history of the workflow this date is one day minus the displayed date on the list.

 

I attached some screenshots , maybe someone  will explain what's happen and how can i resolve this issue.

Thank you

Calculated Column BitrhdayCalculated Column BitrhdayValue in Flow HistoryValue in Flow HistoryValue of calculated Birthday in orginal listValue of calculated Birthday in orginal listValue in Copy listValue in Copy list

  • Hardesh15 Profile Picture
    Hardesh15 7,087 on at
    Re: Power automate flow create item in another list strange behavior

    @ciprianpopovici  When you create calculated column of date type it always subtract default time of that region that is why you are seeing one day less in your list. Add minutes/hours in your flow logic. Example- Region GMT+5:30 This will give me calculated column date with time like 2021-09-22T18:30:00Z so i always add 330 mins to make it equal.

    Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

    @Hardesh /Gopenly.in

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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard