Power Automate flow(Connecting to the foster family table and animal table)

[mcofuzor]

How can connect to both foster family table and animal table to get the animal and foster family details for the mail?

[evahas]

I used "get row by ID" and was then able to add the dynamic content to my email.

[mcofuzor]

I am trying to use "Get row by ID" using the animaldateid unique column but its returning empty record, prevent the trigger from working.

[evahas]

Can you provide a screenshot? What trigger are you using? I used "When a row is added, modified or deleted".

[mcofuzor]

The first image is my trigger setup, while the send the second image the error i get when I try to run it

[evahas]

I only used one "get row" for the related table - maybe taking the one you have for the animal table out would work? I was still able to get the information from the original table without it.

[MorganG]

@evahas how did you get the flow to trigger? I tried just setting it up as one row and it does not trigger when I modify a row in either the model-driven or canvas app. 

[yodalearns24]

For the 'Get a row by ID' for the Row ID; 

1. were you able to see your columns from the table in the Dynamic Content?

2. Did you select the column that has the description 'unique identifier for entity instances?

[MorganG]

@yodalearns24 oddly enough, the flow worked when I switched the table for the "modify/add/delete" action to an extra table I had created, as well as inputting that table and associated unique identifier for the "get a row by ID" requirement.

So there's something up with my Animals table that's not working. I checked the columns to identify which one has the associated unique identifier. However, that column name doesn't come up when I search columns in the Dynamic Content. I experience the same when I try to use the Foster Family table.

[mcofuzor]

I have being able to make it work. The issue was that I didn't pass any variable from the gallery to the the form. I have now passed a variable from the gallery to form through the Item by writing a LookUp function that connected a row from the Foster table with the selected item in the gallery