Hi all,
I have several Dataverse tables in my app. One table lists assets, another lists sites. The asset table has a column to mark which site the asset belongs to, with a lookup column to the Sites table.
I have an existing flow which creates an XML file by taking a list of column values from each item in the asset table. That all works fine. The flow uses the Dataverse List Rows action with the column names listed comma-separated in the action.
I wanted to add another column from the same table to the flow - the name of the site the asset is at. I can see by looking at the column's details that the column's Logical Name is crbbc_sitename, but when I add this column to the flow, the flow fails with a Bad Request error, saying that there's no column of that name in the table?
Should I be using the RelationshipName value? If so that seems to be a bit of a problem too as the value is so long it doesn't all display in the Column Editor. Edit: I tried that and it didn't work either.
thanks
Martin
