You may encounter errors executing or saving data macros that use the SendEmail macro action in an Access web application on SharePoint Online.
Invalid field name 'ID'
This is a product issue.
You may try any of the following options to work around the issue:
1. If the default ID field in the table has been renamed, add a new number field named ID to the table
2. Create a table named "inserted"
3. Move the SendEmail macro action from a named data macro to a table event data macro.
If these options do not resolve the issue or you are unable to make these changes, please wait for issue to be resolved and deployed.
The developers have reported that this issue should now be resolved for all tenants.