I'm using Power Automate to send data to an Excel sheet when a survey is submitted (using Watercraft Invasive Mussels template in Web Designer). The field 'Observation Date' is displaying in Excel as 1669654800000 for Nov 28, 2022.
Based on this post , I entered the formula
addseconds('1970-1-1', Div(triggerBody()?['feature']?['attributes']?['observation_date'],1000) , 'yyyy-MM-dd')
as a function expression in Power Automate. When I run this, the survey submits correctly to the feature layer, but never appears in Excel. Eventually I get an email telling me one of my fields is Null.
Any clues about how to deal with this? Thanks.
