Convert to Power Automate Parameters & Lookups

[rhanoudi]

Hello Rappen,

I've noticed that the tool incorrectly converts the lookup columns to this format (When looking at the column output): _parentaccountid_value

The above format is required for filtering, however when simply selecting columns, all we need is the field name.

Microsoft made this super confusing...

Rayan

[rappen]

Ping @MarkMpn - any thoughts?

[MarkMpn]

I've found if you do e.g.

/api/data/v9.0/accounts?$select=parentaccountid

the JSON you get returned includes every attribute, including _parentaccountid_value. If you do:

/api/data/v9.0/accounts?$select=_parentaccountid_value

then you only get the requested _parentaccountid_value field.