Power Automate to Enterprise - Create a record in a feature layer not plotting properly

Question

I am having two issues with the "Create a record in a feature layer" action in Power Automate. One being that the datetime isn't transferring into the feature layer. What format does it need to be converted to for Esri?

Secondly, I am trying to plot by coordinates but the points are being thrown to null island. Is the geometry input incorrect? The "outputs" next to x and y are the coordinate fields.

alo5108 · Answer

The screen grab below shows the output of the "Create a record in a feature layer" action. The coordinates are populating in the table but not plotting, so I feel like I am missing a step here. I did update the coordinate system after confirming.

The datetime also shows here but does not show in the feature layer. The error in the "raw outputs" is as follows:

"description": "Cannot convert a value of type 'java.lang.String' to 'TIMESTAMP'."

I hope this helps to clarify! Thank you both for your assistance! @Pavel148

RobertAnderson3 · Answer

I am indeed pulling from an existing layer at this point in time. I think the issue as Pavel outlines below is likely that the coordinates you are providing do not match the spatial reference you are giving? Do you know what coordinate system your coordinates are in?

Have you verified looking at the run of your flow what the values being extracted from the email text into these variables actually are?

That DateTime format should work fine, that's how I end up entering it as well. Are the values not passing at all or are they wrong? The feature layer stores times as UTC.

Are you able to share images of your flow, or at least of the sections where you set the XY and time variables, and the Create Feature action?

Pavel148 · Answer

Hello,
From the description, it seems that the coordinates you are using don't match the spatial reference provided.

Regarding time:
Example 1: Using your date format.
12-31-2024 13:30:30 will map to

Example 2:

Will map to:

Could you please provide additional details on the DateTime issue.