Hi all,
I am using "List rows present in a table" and then "Update a row" to update all rows with same Group. I have a Column called "Group" to identify the groups, and a Column "Email_1" I want to update. My table is like the following:
| Name | Group | Email_1 | Email_2 |
| John | A | NA | NA |
| Peter | B | NA | NA |
| Dickson | B | NA | NA |
I am using PowerApps to trigger the flow, and I want to update all "Email_1" for Group B to the value "Sent".
In "List rows present in a table", I entered this table and enter { Group eq "B" } to Filter Query.
Then I added an action "Update a row" and select "Name" as Key Column, then add dynamic content "Name" from the "List rows present in a table" as Key value. But it gave the following error:
{
"status": 400,
"message": "Maximum number of identity column variants for a single table exceeded. Current '2', Maximum '2'. Up to '2' column name variants should be in use across workflows for one particular table.xxxxx",
"error": {
"message": "Maximum number of identity column variants for a single table exceeded. Current '2', Maximum '2'. Up to '2' column name variants should be in use across workflows for one particular table."
},
"source": "xxxx"
}
If the key value I select "Group" instead of "Name", it will only update the first row of group B.
I don't know how to fix this problem, please help! Thanks!
