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

[Anonymous]

Hi,

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.

[v-yamao-msft]

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:

addDays(triggerBody()?['CalculatedDate'],1)

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

Best regards,

Mabel Mao