I'm using Nintex for SharePoint 2016 to create a workflow to automatically send an email weekly to a group of people if certain field are set to something.
Here's what I my flow looks like,
If Certified is equal to 'No' AND Owner is blank
Export the list to excel
Attach the excel to the email notification, send it to the managers
I need help on exporting the list and attaching it to the email. Can some please help. It will be greatly appreciated. Thanks in advance.
Nintex does not provide an option to export the list to excel, instead, use a PowerShell script that performs this job, and automate this script running using a schdule task.
@MykeeLee try below approach: