This project shows how to use Office Scripts and Power Automate actions to select rows from Excel file and use it to send Teams meeting invite and update back Excel.
Example scenario:
- A HR recruiter manages the interview schedule of candidates in a Excel file.
- Recruiter needs to send Teams meeting invite out to candidate and interviewers to eligible candidates. The business rules are to select: (a) invites to only those for whom the invite is already not sent as recorded in the Excel column (b) interview date is in the future (no past dates).
- Recruiter needs to update the Excel file with the confirmation that all Teams meetings have been sent for the eligible records.
The solution has 3 parts:
- Office Script to extract data from Excel table based on conditions and returns an array of objects as JSON data.
- The data is then sent to Teams Create a Teams meeting action to send invites. Send one Teams meeting per instance in the JSON array.
- Send the same JSON data to another Office Script to update the status of the invitation.
This is the input Excel file being used.
The solution uses two Office Scripts.