nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Feature Layer and Related Table records through Power Automate

CORFOPYM_Ingenieria

I have a feature layer (parent table, one) with a related table (child reords, many).

In Power Automate i have created a trigger "When a record is updated" with the related table (child records), but i need to call some fields of the parent table...

The idea is to call a field of the Parent Table (see the image bellow), how i call that field

Help please

Screenshot_2.jpg

Find more posts tagged with

Accepted answers

All comments

NataliyaLys

Here is how the step 4 looks like:

'Parameters' tab:

'Code View' tab:

CORFOPYM_Ingenieria

Hi NataliyaLys

I'm trying..

How did you do step 4?

jcarlson

Does Power Automate have an HTTP Request module?

NataliyaLys

I have a similar workflow. And it has been working for me. I'm still new to the Power Automate, so it might not be the best way to handle it, but it works nevertheless.

1. Step 1, I connect to a child table - 'When a record is updated....'

2. Step 2, I fetch updated record from the child table - 'Fetch updates, changes, or deletions...'

3. Step 3, I get data from a parent table - 'Get data from feature layer'

4. Step 4, I update fields in my child table (using fields from parent table) - 'Update fields in comments...'

5. Step 5, I get data from the child table (so i can send it in an email) - 'Get data from feature...'

I hope this helps.

CORFOPYM_Ingenieria

The idea is to call a field of the Parent Table (see the image bellow), how i call that field?

jcarlson

I use Make, not Power Automate, but I imagine they could be similar for this. We do this very thing in a few of our flows.

When you get the form details in, you can use them to sent an HTTP POST request to the parent layer's query endpoint, and include the child attributes in the where parameter. The returned JSON can include whatever parent feature fields you need, and these can be passed on to other parts of your flow.

CORFOPYM_Ingenieria

Any ideas or workaround?

@IsmaelChivite

@SeanKMcGinnis

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.