cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yvonzim
Helper III
Helper III

Display items from lookup column in email

I have 2 sharepoint lists. One main list with lookup column Name where data is stored as follow:

 

Name: person1;person2

 

it creates new columns where data is also stored with ;

Name email: person1@domain.com;person2@domain.com

etc.

 

i like to present this data user friendly in an email:

 

person1

person1@domain.com

etc

 

person2

person2@domain.com

etc

 

i user powerautomate as follow

 

when new item is created

get item

start approval

if yes

sent email 

 

I tried the Create HTML table but then i have to create a table for every column?

Hope someone can help me

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Yvonzim,

 

I've used the Create HTML table card and I am getting the data from an array variable that shows like this:

image.png

Using the Automatic column setting on the Create HTML table action I am getting all 4 columns adn the data is properly formatted:

image.png

image.png

Can you try and let me know?

 

Thank you,

Ovidiu

View solution in original post

5 REPLIES 5
Yvonzim
Helper III
Helper III

Forgot to say its a multiple select lookup column

a-ovbord
Microsoft
Microsoft

Hi @Yvonzim,

 

Do you mind posting more details of the flow with screen shots?

The columns can be customized in the Create HTML table card or left on Automatic as well:

Annotation 2020-02-24 143821.jpg

Thank you.

Ovidiu

 

I used the html option but that displays the rows only from one column 

I need contactname (lookup) - jobtitle - mobilenumber - in one table.

 

For now I make 4 tables next to each other but that should not be the solution?

 

html flow.PNG

This is how i put it in an email HTML table

 

email html.PNG

 

and it looks like this in the email:

 

Person 1       jobtitle       mobilenumber

Person 2       jobtitle       mobilenumber

Hi @Yvonzim,

 

I've used the Create HTML table card and I am getting the data from an array variable that shows like this:

image.png

Using the Automatic column setting on the Create HTML table action I am getting all 4 columns adn the data is properly formatted:

image.png

image.png

Can you try and let me know?

 

Thank you,

Ovidiu

View solution in original post

Thanks for this option. I will try to instert the array output as sugested in a HTML table.

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (59,115)