Modify values in array

(0) Share

Report

Posted on by gabororsi

I created a flow.

It puts the files/subfolders properties (ID, filename, uploader etc) from a specific folder into a Sharepoint list.

I put the file IDs into filearray.

I put file IDs (column called FILE-ID) from a SharePoint list into listarray.

The problem is the following:

filearray looks like this: [222,225,221,230]

listarray looks like this: ["222","225","221","230","240"]

The column type is single-line text. I tried to change to number but it adds .0 to the value.

I'd like to compare the two arrays but because of this "it always shows differences.

How can I remove/add " from the values of the arrays?

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @gabororsi

Didn't understood completely. How you getting the filter array? Could you please have a screenshot?

Thanks

Was this reply helpful? Yes No
gabororsi 27 on at

Like (0)

Report

LIST

Files

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @gabororsi

Above when you map the File-Id under the append array try to convert to integer using expression int()

Thanks

Was this reply helpful? Yes No
gabororsi 27 on at

Like (0)

Report

I put this into that but I for error
int(outputs('Get_items_LIST')?['FILE-ID'])
or
int(outputs('Get_items_LIST')?['FILE_x002d_ID'])

Unable to process template language expressions in action 'Append_to_array_variable_2' inputs at line '1' and column '21324': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @gabororsi

Add a compose above the append array and map the value. Do not use the int() conversion. Run the flow and see what value it returns. Let me know the results or the screenshot of your flow run history.

Thanks

Was this reply helpful? Yes No
gabororsi 27 on at

Like (1)

Report

Is this how you thought?

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @gabororsi

Nearly there. Expand the compose step under the run history. I am interested in that.

Thanks

Was this reply helpful? Yes No
gabororsi 27 on at

Like (1)

Report

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @gabororsi

Thanks so next step try to append using the above output from the compose by converting to int()

Was this reply helpful? Yes No
gabororsi 27 on at

Like (1)

Report

Thanks for the help so far.

Was this reply helpful? Yes No