Schedule Flow

[Syndicate_Admin]

Hi,

I have created a flow where I want to send an email before the End date to vendors.

I want to send the mail to the vendor I am using Share Point as a data source for 1 too many relationships. The vendor email id column is in
the list called vendor information and the End date column is another list called Assignment. here I want to use the vendor email column in the send to email. how I can do this in the get item I have given the Assignment list of the End date.

Please help. 

[JirkaZ]

How does this relate to Power BI's Power Query?