Power Platform Community Forum Thread Details

Hello,

I'm working on flow that checks new incoming data against pre-existing data for accounts in our database.

It's a bit convoluted, but in short I have a loop which loops through an array of the fields I am checking, so data[0] is "address1_line1". Inside this loop I check two other arrays, newData and oldData which are the corresponding values for the fields so newData[0] is "123" and oldData[0] is "456". However I have a second condition which checks if oldData = null and newData != null whereby I want to update the associated account with the data.

I can't work out how to dynamically update a row. I want to use the data array containing the fieldnames as a dynamic variable to target the field I want to update. So if data[1] is "address1_line2" and newData[2] is "123 ave" but oldData[2] is null. However if I use an Update a Row node it seems I'm limited to manually mapping the fields I want to update whereas I want to update the field corresponding to data[2]

Hope this makes sense - I feel as if I am missing something that's right before my eyes but I'm having a hard time as it stands.

Thanks in advance

Categories:

General topics