Power Automate - Email Lookup field's value

%3CLINGO-SUB%20id%3D%22lingo-sub-2495018%22%20slang%3D%22en-US%22%3EPower%20Automate%20-%20Email%20Lookup%20field's%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2495018%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20new%20to%20Power%20Apps%20and%20Power%20Automate.%3C%2FP%3E%3CP%3EI%20have%20created%20a%20Model-driven%20app%20with%20a%20DataVerse%20backend.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20an%20invoice%20gets%20paid%2C%20I%20want%20to%20send%20an%20email%20with%20details%20of%20the%20invoice%2C%20the%20case%20no%20and%20the%20clients%20name.%20I%20am%20able%20to%20get%20the%20invoice%20and%20case%20details%20I%20need%20but%20to%20get%20the%20client%20details%20I%20need%20to%20go%20through%20the%20case%20table.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20used%20List%20Rows%20and%20Variables%20to%20get%20the%20case%20details.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20much%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2495018%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

I'm new to Power Apps and Power Automate.

I have created a Model-driven app with a DataVerse backend.

 

When an invoice gets paid, I want to send an email with details of the invoice, the case no and the clients name. I am able to get the invoice and case details I need but to get the client details I need to go through the case table. 

 

I have used List Rows and Variables to get the case details.

 

Any help would be much appreciated.

0 Replies