Hi @TonjeWaasjo
Its actually super simple now that I know its a lookup.
You want to use the
Get a row by ID (dataverse action)
In the action, for the Table Name put the Asset table now (Select it)
For the ID you need to use the _Value Dynamic property from your Apply to each loop.
Here is what I need you to do
1. In your Apply to each loop. I need you to DELETE the Get Asset. Please delete it.
2. Once you delete that, I want you to Add the "Get a row by id" Dataverse Action, that I explained up top
3. I want you to Set the table name to the Asset table.
4. For the Row ID here is what i need you to do
Click inside the Box, where you would type it. This will cause the Dynamic Property Window to popup
Like this Example
I need you to give me a screen shot of ALL the properties that are underneath the Get a row by Id action in the Property window. Please scroll down and grab them all. Dont miss any.
I have TableA and TableB. I have a relationship from A to B. I created a Column in TableB Called TableA_TableB for the relationship.
in the properties I need to find the property called TableA_TableB (Value) <== is the GUID pointing to Table A and is what I use in my Get a Row by ID
For you we are looking for the (Value) that matches your Lookup column Name in the installation table. Thats why I need all the properties screenshotted so I can tell you which one it is for sure.
Here is an image of mine in the Property window: NOTE i had to scroll down to get to it.
Now that I have that correctly set in the Action
I added a Compose underneath it. I want to grab the Description Column from TableA. This is JUST like you want to grab the URL from Asset Table. Asset Table = My Table A in this example
After adding I click in the Compose input box, and the Property Box comes up.
I have to find my Get a row by ID action (I renamed mine) and scroll down until I find the Description Dynamic Property. You would be looking for the URL Dynamic Property.
And I click it
Now I run my Flow
And you can see here that I DID retrieve the Description from Table A (Aka Asset Table), by using my Relationship Table (Value) as the INput to the RowId in Table A, Get a row by id
If you do the same yours will work fine.
I would be grateful if you marked this solution as Resolved/Answer and maybe even a Thumbs Up
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
