Power Platform Community Forum Thread Details

Hello,

I have two microsoft forms that I am attempting to automate. I have the automation compete and working for the first microsoft form that updates a Sharepoint List with a users email address and a few other identifiers. I now created a new automation based on the data from the first form and I want to merge in the results based on the users email address so that the new automation knows what users data from the first automation should be added to the html table in a email that is sent at the end.

Here a snapshot of the automation:

2023-02-02 13 02 52.png

When adding the data from the first automation and the sharepoint list the data doesn't show properly in the HTML table like below when added to the email

2023-02-02 13 07 32.png

The "Self-Evaluation Rating" column should pull the data from the sharepoint list and first automation that works. And the "Manager Rating" column should pull the second automation after retrieving the data from the sharepoint list based on the users email address from the first column to match with the Manager's rating in the second column with the data showing in the html table with correct formatting in the email

2023-02-02 13 08 00.png

It seems that I am stuck in this location and not sure how to correct it or if I am doing the automation correctly. When trying to combine the sharepoint list items and the forms items it turns to "apply to each" and then when completed the html table formatting is all out of wack. This is just a short example. of the apply to each

2023-02-02 13 17 38.png