Creating report with text from lookup column

Copper Contributor

Hey all,
I am trying to create a report from a SharePoint list using Power Automate. Everything works except that I cannot get the information from the lookup column to html.
How do I do?
Lookup.jpg

2 Replies

@Undenius for the column that is a lookup type, make sure you select from the dynamic content box column name Value, not just the column name. In the  example below the lookup column name is Almeria so I've selected Almeria Value:

lookupValue.png

 

 

Edit sorry, I 've re-read the post and can see you've already done that. In which case try selecting column name Value and adding it to its own Compose action, then use the outputs of that compose in your html action.

 

Rob

Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott 

I solved it. I changed the column to Kund not to Kund (linked to item).
Now it works 
Lookup03.jpg