Updatecdt function in expression rules

The second parameter of updateCdt needs to be a set, containing an array of properties and new values (array in itself).  So if you're only updating one of the properties of local!Data, it would be an array of 1.  Also, your updateColumn is setting one too many new column indices, it needs to only use the array {1,2,3} instead of {1,2,3,4}.

load(
  Local!data:{
    {Id: 1, order:null},
    {Id: 2, order:null},
    {Id: 3, order:null}
  },

  local!updateColumn: tointeger(
    updatearray(
      Local!Data.order,
      {1,2,3},
      {1,2,3}
    )
  ),
  
  updatecdt(
    Local!Data,
    {
      order:{(local!updateColumn)}
    }
  )
)

Also note: the property name ("order") used in updateCdt needs to match the case as found in the initial dictionary - if you use uppercase as in your example, it will insert a new property with the uppercase "O" instead of replacing what was already in the "order"

Hi @mike I have used the same but still it's throwing me error:
Nested cdts and lists currently not supported.
Please help me

Hi Mike I got the issue updatecdt function works only for cdts I was updating for dictionary that is the issue.

Please paste the updated sample code you're trying?
REgarding the "nested CDTs and lists" error, I was getting similar in my above example prior to wrapping the local!updatedColumn value in tointeger(); i believe the system was seeing it as "list of any type" otherwise which i suppose updateCdt has a hard time handling.

I have tried the same which u have posted

Here's the output I get when using the code I posted before:

 

If you're getting something different, can you post a screenshot?

Also if you don't need the updateArray portion, you can use updateCdt directly if given the correct syntax:

load(
  Local!data:{
    {Id: 1, order:null},
    {Id: 2, order:null},
    {Id: 3, order:null}
  },
  
  updatecdt(
    Local!Data,
    {
      order: {1, 2, 3}
    }
  )
)

 

output:

Actually I will be updating only some part of the array like where ever id is repeating I need to update that order values to some data.
Local!Data:{
{Id:1,order:null},
{Id:2,order:null},
{Id:1,order:null}
}
So I need output array should be like bellow
{Id:1,order:1},
{Id:2,order:null},
{Id:1,order:2}
So to achieve this first I am finding out the id which is duplicate then I am updating that order column
Then apending to main array.

Please tell me to achieve this as I am facing some issues here

There will be only one duplicate value in the id column I.e it will be 1 or 2 or anything only one duplicate item will be there

In that case you simply need to generate a new array for the values needed in the "order" property; you can do this beforehand by whatever logic you need, then pass it into updateCdt().  It just needs to match the length of the local!data array.

In that case you simply need to generate a new array for the values needed in the "order" property; you can do this beforehand by whatever logic you need, then pass it into updateCdt().  It just needs to match the length of the local!data array.