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']}
    }

Комментарии • 2