Power Automate for creating record in feature layer, no geometry

[EthanV]

Goal: When I add a new record to my SharePoint list, I want it to automatically create a new record in my AGOL feature layer. 

Issue: The flow runs great but no geometry is produced. The record is created in the feature layer attribute table but is not mapped.

I have created a flow in Power Automate which follows: When an item is created -> Get item -> Find address candidates -> Create a record in a feature layer. 

(I also tried a flow with the 'Geocode addresses' item but it refused to accept the address even though it was in single line form)

It is events at locations around the city and some locations have multiple records for the same address. 

[abureaux]

Your workflow makes sense and should work. I find with this specific workflow, the issue usually rests with the geometry's syntax.

I can't remember off-hand if "latestWkid" is required, but as this syntax is so particular, I'd try adding it first.

Secondly, it may look correct to you, but the flow may interpret it differently. I would recommend looking at one of your flow runs and inspecting the "Create a record in a feature layer" step. See what the Geometry part looks like. If it looks messy (e.g., lots of extra quotes or slashes), then it is a formatting issue. For formatting issues, I find dropping it into a Compose or Select (workflow dependent) works best.

Regarding the formatting issue for example, I am doing something similar and using a select. This particular step is SO finicky that I even left a note for myself:

[AkshayHarshe]

@EthanV you can use what @abureaux has suggested, I think you may need the latest wkid. Another thing you can do is to use the function (fx) and use the dynamic content within it instead and search for geometry. you should get the topCandidate's geometry.

Hope that helps.