SharePoint List & PowerAutomate Date Operations

Copper Contributor

Hello Geeks!

 

I need help with the Flow I am currently working on.

 

My SharePoint looks like this.

gkfbrokersupport2023_0-1710388842464.png

I wanted to create a Flow that would check the validity of the Payslips. So for example Payslip 1 is dated 31/12/2023 it will only be valid within 6 weeks from that date.

 

I wanted to reflect the date of validity in the column "Valid Until" and will update the "Validity" column to "Valid"/"Outdated".

 

Here's my work so far but it encounters errors such as the date format is incorrect or doesn't match with the current format on the SharePoint list. I have followed the steps from other articles on how to match the format but still the same error shows.

gkfbrokersupport2023_1-1710389169109.png

 

Hope you can help me fix this or better if you could suggest a different approach for this.

 

Regional Formatting is English (Australia) D/M/YYYY

Thanks in advance! :)

 

 

3 Replies

@gkfbrokersupport2023 

Hi,

 

Did you try:

formatDateTime(yourDateField, 'dd/MM/yyyy')
In which section should I format the date?
At the section where you are updating the date.