Power Automate - Building Flows

Unanswered

Converting array to integer

Like (1) Share

Report

Posted on 26 Jul 2024 10:14:47 by CAlvy

191

I am trying to populate a lookup field in my SharePoint list with multiple values. I want to keep the values that are already there and add a new value to it.

To do this, I have appended the current values (Ids of the column) in an Apply to each like this:

I then use another Append to string variable to add the new value.

From there, I use another apply to each and apply a split to the string variable:

I use an append to array variable with

int(items('Apply_to_each'))

So the steps look like this.

The array variable I add to my Update items. However, my array variable is showing up like this:

[" 182\n"," 181\n"," 186\n"] and it's saying not convertible to integer.

What am I doing wrong here and is there a better way I could be achieving this?

Categories:

Business Process Flows

All responses (2)

Answers (0)

CAlvy 191 on 26 Jul 2024 at 14:42:30

Like (0)

Report

Converting array to integer

Hi @rzaneti

Thanks for your reply!

So I needed this as an array so I could update my multi-select lookup column. I was following the answer in this post:

Solved: Updating SharePoint Lookup Column with multiple (powerplatform.com).

What I probably did wrong was not put in my Append to array variable

{

"Id":

}

I corrected this and ran the test again and it worked that time.
rzaneti 4,055 Super User 2025 Season 1 on 26 Jul 2024 at 11:23:50

Like (0)

Report

Converting array to integer

Hi,

Did you try to use an array variable, rather than a string one, and then use the Append to array variable in your loops, rather than Append do string variable?

If you need to work with strings for some reason, you will have to transform your individual arrays items (which are strings) into integers, and for that you will need to use an expression like this: int(trim(replace(uriComponent([your_item_here]), '%0A', ''))).

By using this expression, we are first removing the line break ('\n') by using the replace() method and then removing the blank space at the beginning by using the trim() method. As a final step, we are transforming the final string (which now must look like "182" or "181") into a number by using the int() method.

To learn more about data types or text transformation in Power Automate, refer to these blog posts:

- Data types: http://digitalmill.net/2023/08/03/data-types-in-power-automate/

- Text transformation: http://digitalmill.net/2023/08/12/how-to-extract-and-clean-texts-with-power-automate/

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/

https://www.linkedin.com/in/raphael-haus-zaneti/

Community site session details

Converting array to integer

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Congratulations to the April Top 10 Community Stars!

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates

Community site session details

Converting array to integer

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Congratulations to the April Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates