Skip to main content

Notifications

Power Automate - AI Builder
Unanswered

Extend a date column by one day and insert it into the new column.

Posted on by 11
A date is entered in the EndTrip column. In the new EndTrip+1 column, calculate one day and enter this with Power Automate.
No matter what I do, I always get an error message. 
 
This way I have programmed. What is wrong?
Thank you.
Categories:
  • Amardeep Raj Profile Picture
    Amardeep Raj 18 on at
    Extend a date column by one day and insert it into the new column.
    Hi 

    The error you're encountering suggests that a foreach loop is being applied to a string instead of an array. a foreach loop is designed to iterate over collections, like arrays or lists, but it cannot iterate over a string as it treats it as a single entity rather than a collection of items.
     

    I see the current error:

    Where you are using field_12 in the flow, it should be of array type; currently, it is a string. You can also use the array() function if field_12 contains data in array format.

    If you can show me that part, I can provide a better solution.

     
    If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
  • Leon1976 Profile Picture
    Leon1976 11 on at
    Extend a date column by one day and insert it into the new column.
    I have now taken a different route. 
    Now I have a different problem. It says that there is nothing entered in the field_13 date column, even though it says date in the column. Why?

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

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,523

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,707

Leaderboard