Power Platform Community Forum Thread Details

Maximum number of identity column variants for a single table exceeded.

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!

Quick Links

Leaderboard