Oct 28 2022 01:20 AM - edited Oct 28 2022 04:34 AM
Hi All,
I'm a basic Power Automate user so looking for some help. I can see Bookings now works with Power Automate.
Is there a way to create a power Automate to Update a staff training tracker (Excel Spreadsheet) once a course has been completed - or even when a booking is made.
I have similar Power Automates running with MS Forms, so when a form response is entered, it updates a line on a spreadsheet. I'm using this for course feedback, NPS stats etc.
I'd like to use this same approach to limit the admin work of keeping training trackers updated. Even if it updates the spreadsheet on booking, it will be less time to just delete the attendee that maybe couldn't make the booking - rather than updating it each day with attendance for multiple bookings.
The TSV file you can get out seems annoying, isn't intuitive and I have to convert in order to see it in Excel. Seems odd that there isn't just an easy Excel export - Longer than 120 days!
Any help would be greatly appreciated :)
Thanks in advance,
Jess
Nov 09 2022 09:57 PM
Dec 14 2022 03:18 AM
@JessicaBenjamin Did you manage to create the flow and are you also missing info from the custom fields?