Suppose we want to retrieve the value of the source campaign lookup of the lead records.
The schema name of Source Campaign is – campaignid
To get its GUID in the Select columns of list rows we can specify it as
_campaignid_value i.e. _lookupschemaname_value
The other option is if we specify the schema name in select columns then we need to use the expand property to get the GUID as well if we want any other attribute values e.g. text/label of the lookup field.
Hope it helps..
One thought on “List Rows, Select Columns, and Lookup field – Power Automate / Dataverse”