I have a SharePoint Online list (Modern experience) that has a Plumsail Cross-site lookup field named "Name". I would like to use that field on a Microsoft Power Automate flow, but the "Name" field does not appear on the list of fields that I can select. To overcome this, I tried to use JSON column formatting on my list to assign the value of the "Name" field to the "Title" field; but the only thing that comes up on the "Title" field is "[object Object]". My JSON code is below:
The Cross-Site lookup field is still a lookup field. In Power Automate the lookup fields have ID and Value next to the field name. So you need to search for these values in the list of the available values:
Where Name ID will return the ID of the target item as an integer and Name Value - the displayed value of the lookup field.