Errors executing or saving data macro with SendEmail action in Access web app on SharePoint Online

Issue:

You may encounter errors executing or saving data macros that use the SendEmail macro action in an Access web application on SharePoint Online.

Errors:

Invalid field name 'ID'

Invalid object name 'Inserted'

Cause:

This is a product issue.

Work Arounds:

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. 

Status:

The developers have reported that this issue should now be resolved for all tenants.