Power Platform Community Forum Thread Details

Hello All,

I have a scenario where I need to inner join two tables (A & B) from SQL, Table A has user emails & App ID and Table B has Application names & App ID associated with Table A.

I have to send reminder emails to user email and in the body of the email I need to list all applications that user is associated with (below is the SQL query), I am trying to implement same using Transform data using Power Query in Flow and do an inner join in merge table but for some reason I am not able to find user email in dynamic values to set them in To of email(I see it is listed as table in merge table) and how can I list all applications associated for that user in email body?

SELECT *

FROM ITSupport AS A INNER JOIN ApplicationMatrix AS B ON A.ApplicationMatrixId = B.Id where A.SupportTypeId = 1 AND A.IsActive = 1

Thank you in advance!