Forum Discussion
Creating report with text from lookup column
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?
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:
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
