Enumeration error

AppSheet AppSheet Q&A
,
1

I get an enumeration error when trying to do an action on add from a workflow but when I click the action in a view it works fine? The action adds a row to a table.

2

Please post a screenshot of the error.

3

3X_1_c_1c35c18f590cc20d0640e0d3683f03d062715f1c.png

Oh man so small

1 Like
4

_RowNumber is your key?! Oh, Austin… Yer killing me, man!

It’d help to see the action configuration. I’d guess you’re trying to set an Enum or EnumList column value to a value that isn’t a defined value and the column doesn’t allow other values.

5

@Steve
I think Reports could be having issues. I have actions that work perfectly when used from a view or called from a workflow but fail when run from a report. Note the similarities in error messages:

“Errors”: "Error: ‘Execute a Sequence of Actions’ Grouped action ‘ComboCopyDonorRequestsSetAdded’ child action ‘CopyDonorToRequests’ failed due to error: Error: Perform DataAction ‘CopyDonorToRequests’ failed because Row having key ‘22b2f18e’ in table ‘Requests’ in field ‘START_DATE’ is required to have a value. \nError: ‘Add Row’ Data action ‘CopyDonorToRequests’ failed with exception Collection was modified; enumeration operation may not execute. .",

I have a post about it with screen shots of my actions.

[Combo action works from deck view but not in a workflow](https://community.appsheet.com/t/combo-action-works-from-deck-view-but-not-in-a-workflow/32503) Questions

I am copying rows from one spreadsheet to another through my app. Basically importing them and adding the column values as needed. This works as an action on a view. I use it in a combined action, image #3. [Screen Shot 2020-10-15 at 2.34.34 PM] This works as well. I use it in a combined action, image #3. [Screen Shot 2020-10-15 at 2.34.49 PM] This is the combined action. Works perfectly from a deck view. But it won’t work when called from a Report. [Screen Shot 2020-10-15 at 2.35.05 PM…

1 Like
6

Dont insult me like that

3X_a_8_a8f47e870239dfe32d06398603e72f4cd40576f0.png
3X_a_8_a8f47e870239dfe32d06398603e72f4cd40576f0.png917×436 21.2 KB

I have a proper key and its being set manually in the action and has an initial value.

3X_a_4_a43607e0091b96c64a9541f8d811b4f4f5c80fbb.png
3X_a_4_a43607e0091b96c64a9541f8d811b4f4f5c80fbb.png818×720 34.3 KB

Milestone and Initiative are References to Projects, and Project_Milestones.
Status is an Enum.

2 Likes
7

Hi @Austin_Lambeth
I dont see your key column in there?

2 Likes
8

Austin_Lambeth:

I have a proper key and its being set manually in the action and has an initial value.

So here’s the thing I’ve noticed with Data: add a row to another table using values from this row: the Initial value expression for the key column value for the new row is evaluated before the columns set by the action are given their values, so the key column’s Initial value expression does not have access to those new values. Would this affect your action?

1 Like
9

Well it was originally using the initial value and it was not setting the key from the action. This action is being triggered by an ON ADD workflow. Would that make a difference too? Its referencing the added milestone through Milestone_ID. Is this a chicken and the egg? The milestone doesn’t exist before I’m trying to set the reference to the milestone?
The enumeration error on rownumber is a very odd one. My Initial Value is MAX(Project_Details[Detail_Key])+RANDBETWEEN(1,500) so is it trying to grab a value based on itself?

10

I noticed that too. I guess my co-developer was in the app when I made that change but I tested it this morning with it in there for sure and it still errored the same.

11

Austin_Lambeth:

This action is being triggered by an ON ADD workflow. Would that make a difference too?

Workflows run after the added/updated/deleted row has been added/updated/deleted.

12

Austin_Lambeth:

Its referencing the added milestone through Milestone_ID. Is this a chicken and the egg? The milestone doesn’t exist before I’m trying to set the reference to the milestone?> The enumeration error on rownumber is a very odd one. My Initial Value is MAX(Project_Details[Detail_Key])+RANDBETWEEN(1,500) so is it trying to grab a value based on itself?

I’m completely confused by this.

13

So [milestone_ID]=[Milestone_ID]
I think your previous answer disproves this but I was wondering if the Milestone_ID was not valid because it didn’t exist yet.

The second part is me asking about the enumeration error cause its around the rownumber field which has no user control so its very weird that it is erroring.
My last statement confuses me too. Its early

1 Like
14

For now my solution as is becoming more often than not is, avoid appsheets method and go to a database trigger