Feb 22 2019 07:30 AM
Hi All,
So I've been able to use the 'Get Data' method to hook into my bookings exchange account and when I select on 'Meeting requests' in the Power Query editor I can only see the sent items for the meeting requests.
This gives me a good starting point as I can see which requests have been cancelled but the problem I now face is that if I edit a bookings request, it creates a new entry and doesn't remove the old one so I end up with duplicate entries.
There is no common key between the two entries so I'm unable to find a way of removing the old request and just leave the latest one.
Hope this makes sense but does anyone have any ideas?