web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Multiple insert list c...
Power Automate
Unanswered

Multiple insert list cannot be executed

(0) ShareShare
ReportReport
Posted on by 407

I want to insert multiple variable items into the list at once, but I can't do it. What's the problem?

螢幕擷取畫面 2023-07-06 234409.png螢幕擷取畫面 2023-07-06 235057.png

I have the same question (0)
  • Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    The Add item to list action does not allow adding multiple items at once. It only supports adding one item. 

    What you can do instead is use Set variable to create a temporary list with all of your values like this:

    AgniusBartninka_0-1688701494829.png

    And then use Merge lists to merge your original list with this temporary list. What this will do is add all of the values from the second list to the end of the first list. You can then make it store the output in the same original list, effectively overwriting it with the new merged list.

    AgniusBartninka_1-1688701561922.png

    While this requires two actions instead of one, it is still much more efficient than adding all of those values one by one.

     

    -------------------------------------------------------------------------
    If I have answered your question, please mark it as the preferred solution.
    If you like my response, please give it a Thumbs Up.

    If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/

     

  • alee001 Profile Picture
    407 on at

    I have tried this method before and it cannot be executed. You can notice that the current value of the run_TS variable is different (red circle).

    螢幕擷取畫面 2023-07-07 205033.png螢幕擷取畫面 2023-07-07 205344.png

  • Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    I have no idea what most of those actions are, but I can see you are doing a For each loop, meaning that your current value is a single item from the list, and not a list on its own.

  • alee001 Profile Picture
    407 on at

    I just don't understand that the list only accepts adding items one by one, but not consecutively adding items?

  • Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    It does accept it. You have already done it in actions #43 and #44 of your screenshot above. I don't really understand what it is that you expect.

     

    It would be 100x easier to help you if you changed the language of your PAD to English. See this video on how to do it: https://youtu.be/l2zpRkUBk0o

     

  • alee001 Profile Picture
    407 on at

    If this method is feasible, it will save process time, but it is a pity that it cannot be executed in a loop as shown in the figure, because the item is a string and not a variable.

  • Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    A string is a variable type. There is some serious communication issues here, as you do not seem to understand what I'm trying to say, and you are not really explaining what you are trying to do. Your screenshots do not help either, as they're localized and I do not understand the language.

     

    If you want help, I suggest you try to change the language of PAD to English. I would then at least be able to understand the actions you're using and maybe then I could tell you what you are doing wrong there.

     

    It is clear that merging the lists like I explained above actually works. It's just whatever you are trying to do with the list AFTER the merge that does not work. And I cannot comment on that, because you have not explained it.

  • alee001 Profile Picture
    407 on at

    Sorry for the communication problems caused by the language, I just want to save time in the process, as you can see in the picture, what's your opinion?

    list.png

  • Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    You cannot pass a string from a list as a Window instance. A Window instance is a special type of variable created by PAD when you use the Get window action. You cannot reproduce that by simply adding some strings to a list.

     

    Instead, you could try doing something similar if you were focusing the window based on its Title and class, which is an option in the Focus window action.

  • alee001 Profile Picture
    407 on at

    For each opened file to set variable as Window instance, it is necessary to use [Get window]. Retrieve the current file to be executed in the loop, [Focus window] can only select Window instances, other options are not applicable at all, the problem is that the list does not accept your method (array) as a Window instance.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 474

#2
11manish Profile Picture

11manish 268

#3
David_MA Profile Picture

David_MA 243 Super User 2026 Season 1

Last 30 days Overall leaderboard