Dataverse Lookup Field Blank in List Rows step

(0) Share

Report

Posted on by AnthonyIsAdulti

Hi everyone,

I have a Power Automate Flow step that is the "List Rows" step for Dataverse. Right now I am trying to put a lookup field in my "List Rows" (Dataverse) step, however when the flow runs it just shows up as blank. Is there any resolutions for this whilst using this step or do I have to go for another solution? The other more normal fields such as text and GUID's are showing up, just not the two lookup fields I am pulling.

Many thanks.

Categories:

Business Process Flows

Screenshot 2025-1...

I have the same question (0)

All responses (1)

Answers (0)

BabyBots 236 on at

Like (0)

Report
Dataverse Lookup Field Blank in List Rows step

Lookup fields won’t return directly in “List rows.” Use the hidden value column instead.

Step 1 — Add this in Select columns:

_<lookupname>_value

Step 2 — Access the GUID like this:

item()?['_<lookupname>_value']

(Optional) If you need the lookup’s name, use Expand Query:

lookupname($select=name)

Then reference it like:

item()?['lookupname']?['name']

🚀 Automate. Optimize. Innovate. 🚀

Helping businesses streamline workflows and maximize efficiency with Microsoft Power Platform. Let’s transform your processes and unlock new possibilities!
Explore BabyBots.ai

Was this reply helpful? Yes No