cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted

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
Highlighted
Helper III
Helper III

Forgot to say its a multiple select lookup column

Highlighted
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

 

Highlighted

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

Highlighted

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

Highlighted

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Users online (8,055)