My flow works as a customer service platform using a form from microsoft forms , a list in sharepoint and power apps:
1. when the customer write the requirement in the form a new item is created in the list in sharepoint.
2. the requirement has now a pending status.
3. the representative solve the requirement and could attached any file in the app if its necessary.
4. when the ticket is solved the status changes, and a flow send an email to the client.
What I need if the solution comes with an attachment, we need to send the email with that attachment if the status is solved.
Could you help me, thanks in advance.
Thank you it worked, I appreciate your time to help me.
Hi @FelipeUr ,
When the ticket is solute, flow wants to send an email with an attachment to the client.
First, make sure that there is a client email column in the SharePoint list.
I did a test for your reference.
In my scenario:
Set conditions in triggers.
@equals(triggerOutputs()?['body/Estatus/Value'], 'Solved')
{
"Name": @{items('Apply_to_each')?['DisplayName']},
"ContentBytes": @{body('Get_attachment_content')}
}
My SharePoint List:
Best Regards,
Sunshine Gu