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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Enter Multiple ID's at...
Power Automate
Unanswered

Enter Multiple ID's at Once Using the Select Data Operation

(0) ShareShare
ReportReport
Posted on by

Hello, I wish to select multiple items from a list on SharePoint. I am using the select tool to search for the ID's (Project Numbers), but I have to manually enter each one which would take me very long. Is there a way for me to enter all of them at once? I looked at the Map to Text tool but it removes all of the projects I have already entered except for the most recent one. 

 

Below is an example of what I'm trying to do. 

 

shaheerl_0-1675108905080.png

 

Categories:
I have the same question (0)
  • David_MA Profile Picture
    12,966 Super User 2025 Season 2 on at

    Select does not work how you are attempting to use it, as you have it reversed. The SharePoint fields go on the right side in the "Enter Value" column. The Enter key column would be like the header row of a spreadsheet and represents the value you want to use as a column name. In many cases you would follow the Select action by a Create HTML table action, which as the name implies, creates an HTML table. You could then send this in an e-mail message or export it as a CSV file.

     

    Below is an example of how to correctly use the Select action:

    David_MA_0-1675110837830.png

    Your result will be a table with data specified from all of the items in your Get items action.

  • grantjenkins Profile Picture
    11,063 Moderator on at

    Are you trying to filter your items returned from your List, just get a list of all the Project Numbers that are contained in your List, or something else? Not quite sure what you're trying to achieve here.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard