Power Platform Community Forum Thread Details

I have two sharepoint lists: company and client

Company list

ID	CompanyName	task	Emails	Status
1	abc	Providing training on social media	abc@site.com,xyz@site.com	completed
2	xyz	provide presentation	xy@site.com,zy@site.com	approved
3	abc	held meeting	abc@site.com,xyz@site.com	onGoing

Client list

ID	CompanyID	DocumentType	attachment
1	1	Memo	documentAttached
2	1	Handover	HandoverDocumentAttached
3	2	Memo	attached

companyID in ClientList is a lookup column that refers to ID of CompanyList.

Emails in CompanyList is Person data type.

Now example: I want to send atachment link of file on ClientList with DocumentType "Handover" via email to the emails in the companylist's Emails with ID 1.

ClientList for each ID from Company has only one document with "Handover" name but It can have any other document types too. and ClientList each row only have a single attachment.

I want to send the handover attachment link via email when a CompanyList status is changed from "Approved" to "Completed".

I tried the following but not working