Power Platform Community Forum Thread Details

I have 2 Sharepoint Lists named "Test A" and "Test B". Each of this list has 3 rows and 3 columns of values, with the column name being "A", "B" and "C". I am interested to add column "A" in "Test A" and column "A" in "Test A" and have the output column in column "A" of another Sharepoint List called "Test C".

In the trial Lists that I have created, column "A" of "Test A" contains doubles "1, 1, 1" while column "A" of "Test B" contains doubles "4, 7, 10". Ideally, I should see "5, 8, 11" under column "A" in "Test C" as an output.

I have created a flow, however, it encounters an error on the last step (Create Items), claiming that the input is not of a number or double. I have searched for many ways to address this, including conversions but it does not work. Here is the full error message "OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/B' is required to be of type 'Number/double'. The runtime value '"float(outputs('Compose_3'))"' to be converted doesn't have the expected format 'Number/double'."

If anyone could provide some assistance for debugging, that would be awesome. I have attached the flow and lists in the attachments.

Categories:

Building flows

Hi,

Please try the following:

I used the following expressions:

range(0,length(outputs('Get_items')?['body/value']))

add(outputs('Get_items')?['body/value']?[item()]?['A'], outputs('Get_items_2')?['body/value']?[item()]?['A'])

If columns A, B and C are text strings, then convert them to integers:

add(int(outputs('Get_items')?['body/value']?[item()]?['A']), int(outputs('Get_items_2')?['body/value']?[item()]?['A']))

The range function will give us a range of numbers starting from 0 to the length of the Test A list (in this case the range will be 0, 1 and 2). The range will be used to reference list Test A and Test B so we can add up the numbers for each row.