Hi I'm trying to create a flow that runs on a schedule and creates an item to another sharepoint list from a sharepoint list.
my list has dates, multiple choice columns and there are no null values. I've also added formatting that should convert the date stored to the ISO format. below is the expression I am using for dates.
if(empty(items('Apply_to_each')?['field_1']),'null',formatDateTime(items('Apply_to_each')?['field_1'],'yyyy-MM-dd'))
I still get the 400 error message bad request error message:Item could not be created. Check if input is valid.\r\nclientRequestId: 2d311a27-72c1-4e30-8a6d-3c5a8233cb52\r\nserviceRequestId: 2d311a27-72c1-4e30-8a6d-3c5a8233cb52