Showing results for 
Search instead for 
Did you mean: 
Not applicable

Flow to copy calculated (date) column of a list to another list's date column



I have two SharePoint lists: Comp List and Records List. Comp Request has a calculated column(date) called 'Credit Date'. In the Records list I have column setup as Credit Date (Date and TIme).


Using when a new item is added trigger, I would like a flow to trigger on Comp request whenever a new item is added to it, get those items and then I would like to copy/create that item in the Records list and especially Credit Date value from Comp list should be copied over to Credit Column in the Records List, is this possible to do? Please help me with the flow, thanks.


Flow would be pretty simple, when item added trigger->get items->create item, I am stuck at bringing calculated (date) column value from one list to other list's date column.

Community Support
Community Support

Hi @Anonymous,


Do you want to copy the calculated (Date) column from one list to another list’s Date column?


I have made a simple flow to test this issue, the flow is configured likes below.


Per my test, the calculated date would be off one day on another list, so I use a function to add 1 day on the calculated date using the code:



It then works fine. Please take it for a reference then try with it on your side.



Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,638)