Get Lookup Column from Get Row by ID

(0) Share

Report

Posted on by apol3

Hi All,

I have a Flow that leverages dataverse tables and gets a Business Unit's information. One of the columns of the Business Unit table that I added is a "Financial Ops Rep" column that is simply a lookup to the Users table. What I want to do is dynamically get the Financial Ops Rep that is associated to a record by first getting the Owning Business Unit of the record, using that to get the BU info (including the Financial Ops Rep), and then getting the email info (from User table) of that person.

In my brain, this is super straightforward, but for some reason, I can't seem to actually use the "Financial Ops Rep (Value)" column in the Get Row by ID step that gets a User's info. Does anyone know what I'm doing wrong?