You’re offline. This is a read only version of the page.
127
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
also I forget to add status condition. Your usual support is appreciated.
Share
Report
All responses (
Answers (
