Power Automate:-Send SharePoint list entries(Multi-select choice column)as Excel attachment in Email
HTML-код
- Опубликовано: 2 сен 2022
- Power Automate(MS Flow)/ Power Platform /Microsoft 365 /Send SharePoint list entries (only selected columns) as dynamically created Excel attachment in email (includes multi-select choice columns values also)
Files are also available in SharePoint Document Library as monthly historical record.
xpath(xml(json(concat('{"root":{"choices":', item()?['Beneficial_x0020_Areas'] , '}}'))), '/root/choices/Value/text()')
{
"EmployeeName": @{items('Apply_to_each')?['EmployeeName']},
"ProjectName": @{items('Apply_to_each')?['Title']},
"ProjectDetails": @{items('Apply_to_each')?['ProjectDetails']},
"Dept.": @{items('Apply_to_each')?['Dept_x002e_/Value']},
"BeneficialAreas": "@{xpath(xml(json(concat('{"root":{"choices":', item()?['Beneficial_x0020_Areas'] , '}}'))), '/root/choices/Value/text()')}",
"ApprovalStatus": @{items('Apply_to_each')?['ApprovalStatus/Value']}
}
Hi Mahuz, how can we download automatically in that same scenario
🅿🆁🅾🅼🅾🆂🅼 👍