Hi @diane.reddick40501

Yes, Power Automate is an excellent solution for automatically tracking attendees from a Teams meeting into Smartsheet. Since the attendance report cannot be automatically uploaded to OneDrive or SharePoint, a workaround is to manually upload it to a designated folder, which then triggers a Power Automate flow.

Steps to Automate Attendance Tracking:

1. Set Up a Power Automate Flow
   • Use the "When a file is created in a folder" trigger (for OneDrive or SharePoint).
   • Ensure that this folder is where you upload the attendance reports manually.
2. Extract Attendance Data
   • Since the CSV report* does not have a structured table format, use Text and Array expressions in Power Automate to split and filter relevant sections:
     • Summary (Meeting Title, Start Time, Duration, etc.)
     • Participants (Name, Email, Join Time, Leave Time, Role)
3. Insert Data into Smartsheet
   • As @Isaac A. commented, Power Automate does have a Smartsheet connector, so once you get the necessary information from the report, you can add rows.
   • Use the "Add a row" action from the Smartsheet connector.
   • Map extracted fields to appropriate columns in your Smartsheet.

(*)

Additional Notes:

• You don’t need to be an Office 365 Admin or a Smartsheet Admin. Being the meeting organizer or having access to the attendance report and the target Smartsheet is sufficient.
• The Smartsheet connector in Power Automate allows easy row additions but does not support complex data manipulations natively—hence, parsing the CSV correctly is the most challenging step

Details of setting up Power Automate are beyond the scope of this community. However, if you need further assistance, you can contact me via email at my profile page.

Hope this helps! 😁