Forum Discussion
Help requested: TSV Export Leaves Staff Column Blank
When I export any Bookings page to a TSV file, the Staff column is always blank. The column is there but all the column cells are empty. This is one of the main areas where my customers want analyti...
This blank “Staff” column in Microsoft Bookings TSV exports is a known issue, and it’s affected many organizations, particularly since late 2023 when Microsoft changed some back-end logic for privacy and data processing.
Use Power Automate to capture appointments and include staff info
Instead of relying on the export:
- Create a Power Automate flow:
- Trigger: When a new event is created in the shared calendar (Exchange)
- Action: Parse the organizer or assigned staff and store it in SharePoint, Excel, or Dataverse
- You now have a full dataset with:
- Date/time
- Service
- Customer
- Assigned staff
This provides real-time data collection and is exportable to Excel or Power BI.
------------------------------------
Don't forget to mark as solution if my answer suits you