Modify values in array

Like (0) Share

Report

Posted on 3 Mar 2021 17:50:24 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?

All responses (12)

Answers (1)

gabororsi 27 on 05 Mar 2021 at 09:44:26

Like (1)

Report

Re: Modify values in array

It's working.
Thank you.
Verified answer

abm abm 32,464 Most Valuable Professional on 05 Mar 2021 at 09:26:35

Like (1)

Report

Re: Modify values in array

Hi @gabororsi

Your compose int() expression step should be inside the loop and the append step as well. What we are trying to do here is converting the string into an int.

Thanks
gabororsi 27 on 05 Mar 2021 at 08:47:32

Like (1)

Report

Re: Modify values in array

Thanks for the help so far.
abm abm 32,464 Most Valuable Professional on 04 Mar 2021 at 20:12:18

Like (0)

Report

Re: Modify values in array

Hi @gabororsi

Thanks so next step try to append using the above output from the compose by converting to int()
gabororsi 27 on 04 Mar 2021 at 18:59:51

Like (1)

Report

Re: Modify values in array
abm abm 32,464 Most Valuable Professional on 04 Mar 2021 at 18:40:34

Like (0)

Report

Re: Modify values in array

Hi @gabororsi

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

Thanks
gabororsi 27 on 04 Mar 2021 at 18:34:53

Like (1)

Report

Re: Modify values in array

Is this how you thought?
abm abm 32,464 Most Valuable Professional on 04 Mar 2021 at 17:45:00

Like (0)

Report

Re: Modify values in array

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
gabororsi 27 on 04 Mar 2021 at 17:37:09

Like (0)

Report

Re: Modify values in array

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.'.
abm abm 32,464 Most Valuable Professional on 04 Mar 2021 at 13:29:30

Like (0)

Report

Re: Modify values in array

Hi @gabororsi

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

Thanks