Lookup fields not showing up in "List records" action in Power Automate

[Hetvik]

I have a table in dataverse with lookup columns .when I am using power automate "List records"  to get the records it is not bringing the lookup fields in the result set .

How do I get the lookup fields value in my result set.

I am not using any filters in the action just plain get list records action in the flow.

[PieterVeenstra · Accepted solution]

Hi @Hetvik you should be getting the lookup columns. They should appear with the IDs of the looked up table as a value.

[Hetvik]

I need to use fetch XML query in the action to get the values of lookup column