cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hwielen
Frequent Visitor

Looking for an example how to retrieve a value from an item in a SharePoint list

I'm new to Power Automate and I want to create a workflow but can not find the exact information I need.

 

I have a simple list in SharePoint with a few columns. One column contains unique ID's.

 

What I want to do from the workflow is select an item from the list with a certain ID and then retrieve the value from another column of that item in a variable in the workflow for further processing.

 

The workflow is triggered by an incoming email that contains the ID in the bodytext. I already figured out how to get this ID from the email into a variable.

 

I know there are actions like GetItems and GetItem but i can't figure out how to use them.
I already searched this community but can not find the exact details I need.

Can someone please post an example for the steps / actions I need and the code for the query?

1 ACCEPTED SOLUTION

Accepted Solutions
hwielen
Frequent Visitor

Ahaa! Thank you! 🙂

View solution in original post

19 REPLIES 19
abm
Super User
Super User

Hi @hwielen 

 

To retrieve a record from the list with a certain ID you need to set your Filter Query. Under the filter query set the SharePoint columnname, operator and mapped value. If its string then add single quotes around it. 

 

image.png

 

Next add a foreach action step to iterate the values. For single or multiple records you need a foreach record to retrieve the record(s).



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
Anonymous
Not applicable

Hello @hwielen 

 

You can use the Get item action and put the variable in the Id field as below:

 

Annotation 2020-02-19 105950.png

 

Alternatively, you could use Get Items then use the Filter Query to the below to only retrieve the item you want - if you are only wanting one Item to return you can use Top Count to only retrieve a single item.

 

ID eq 'outputs('Compose')'

 

Annotation 2020-02-19 110144.png

 

Hope this helps 🙂

 

Thanks

 

Bradley

hwielen
Frequent Visitor

Hi abm,
Thank you for your reply.

 

The column I'm filtering on always returns only one item/record because the values in this column are unique.

Do I still have to use a foreach action?

 

And how does this foreach action look like? How can I retrieve the value from another column?

 

How does the expression look like that you use in the 'Limit Columns by view' field?

Also how can I check if no item is found?

 

Hi burgett94,

What is the function of the action 'Compose' with 'Inputs' is 1? Why do I need that?

I guess I need to put the text string to search for in the field ID in your first example? 

But how does the query know in which column I want to search?

 

Also it's not clear to me how the result that I get back looks like.

What extra step do I need to retrieve the value from the desired second column in the list for the returned item?

 

@hwielen with the Get items, even if you are only returning 1 item via the filter query you will still have the apply to each. That is expected and quite normal.

For follow-on actions you can select the other columns from your list from the dynamic content box on the right.

In the filter query you enter your column name and what value you are expecting back, as in the following examples:

filterQuery4.png

 

FilterQuery2.png

filterQuery3.png

Rob

Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks. 

Anonymous
Not applicable

Hi @hwielen 

 

The Compose was me simulating the ID number, so you mentioned you had managed to extract the ID number from the email - so it is where I have put my compose output is where you will put your output from the email.

 

Once you have that, all the columns within the default view within SharePoint will be available for you to use in whatever format you would like.

 

Looking at my screenshot below, you can change the view the action looks at by choosing from the dropdown highlighted yellow.

 

I have used another compose after to show that I could pull the Amount Paid from my list for item ID 1. Using this, I could use another action instead of the Compose like Send email or post message on teams to notify other users or Create item to create another item in another list using details from ID 1.

 

Annotation 2020-02-19 130658.png

Hi burgett94,

Now it becomes a bit clearer to me.

 

But I think there's some misunderstanding about the ID i'm using.

The ID is nothing more than a string value that I entered by hand for every item in a custom column I added to the list and that's unique for every item. It's not a record ID that's generated by SharePoint.

 

So I guess that I have to do some search first with the string value in the correct column to get back the item/record i'm looking for.

 

Should I combine the actions 'GetItems' (for the search) and 'GetItem' (for retrieve the item columns) to get what I need?

 

Hi @hwielen & @Anonymous 

 

If you planning to use @Anonymous  suggestion (Get Item) you need to Id of the SharePoint item record. Then you don't need to use the for each loop to iterate the values. You can directly map the dynamic variables in subsequent steps.

 

For Get Items it may return one or more so you need to use For Each (Control) action step to iterate the values. 

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
abm
Super User
Super User

Hi @hwielen 

 

It's all depends on your flow logic. If you have the Id then you can use Get Item. If you don't have the Id then use Get Items and use filter query to extract the values.

 

If you need further help post a screenshot of your SharePoint list. Then explain what filter you are trying to do and rest of the logic. 

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
Anonymous
Not applicable

Hello @hwielen 

 

You can have it set so that you select the item from the SharePoint List to trigger the flow for that item - would that work better rather than an email?

 

This way it will have the ID in the trigger which you can use for the Get Item action which means you can use any columns in your other actions.

 

Annotation 2020-02-19 135433.png

hwielen
Frequent Visitor

Your're confirming what I just tought.

 

Can I use 'GetItems' to retrieve this ID and than use 'GetItem' to retrieve the Item and it's columns?

Or is there a better way to do a search for this ID?

Unfortunately that is not an option.

I have to use a trigger for incoming email messages.

These contain Project numbers (the ID's) I have to lookup.

 

 

Anonymous
Not applicable

@hwielen 

 

Ok, so you will want to use the Get Items filter query to say [columnprojectid] eq '[outputfromtrigger]' - below is an example of one of mine:

 

Annotation 2020-02-19 141036.png

 

So to explain, the Title is referencing the column "Title" in my SharePoint List then eq means equals to then 'Outputs' is the output of a compose holding a value provided from Power Apps.

 

More details of the Filter Query can be found here: https://docs.microsoft.com/en-us/previous-versions/dynamicsnav-2016/hh169248(v=nav.90)?redirectedfro...

 

I have it set to Top 1 so that it only provide one output which still forces an Apply to each when I do a Update Item but at least this way I know it will only do it the once.

 

Hope this helps

 

Thanks

 

Bradley

 

 

And I can use the output of this 'GetItems' example as input for the ID-field of the 'GetItem' action?

 

Anonymous
Not applicable

Hello @hwielen 

 

With the Get items action that will do everything you need as it will pull all the required columns, so you won't need to use the Get item action after.

 

Thanks

 

Bradley

Hi guys,

Thanks for your help. I managed to retrieve the list value I needed.

 

See the screenshot for the steps I created (the workflow is in Dutch).

 

I still have a question:

What's the syntax for the value in the field 'Limit columns by view'

 

Grtz,

Henry

 

Power-Automate.png

There's no syntax, you should just be able to select the view. Occasionally I have found it has taken several saves of the flow before it's found the different views.

Rob
Los Gallardos

Go to your SharePoint List or library

 

image.png

 

Create the view and specify the columns you want.

 

Then go to flow and create the SharePoint connector. You should be able to see this view under that

 

image.png

 

If you have created the view after the connection then you may not see the view straight away.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
hwielen
Frequent Visitor

Ahaa! Thank you! 🙂

Helpful resources

Announcements

Check Out the February 2024 Dynamics 365 Newsletter

Some of our most active Power Platform Community members are also active in our D365 Community. This month, we are excited to share the latest news from the D365 Community with you.   Our Dynamics365 Community has updated yet again! Since launching in June of 2023, the new Community has seen consistent updates and exciting new ways to feature and celebrate its members. In the latest edition of the Dynamics365 Community newsletter, you can see the new Leaderboard feature! This feature showcases which Community members have earned the most points over the previous month, enabling them to see how they are doing with their engagement--and their progress toward Super User status. Visit the leaderboard for yourself: https://aka.ms/d365clb     Read the whole newsletter featuring the new leaderboard as well as the D365 Monthly Community Member spotlight, FastTrack Tech Talks, upcoming events, and more. February 2024 Dynamics 365 Community Newsletter

Celebrating a New Season of Super Users with Charles Lamanna, CVP Microsoft Business Applications

February 8 was the kickoff to the 2024 Season One Super User program for Power Platform Communities, and we are thrilled to welcome back so many returning Super Users--as well as so many brand new Super Users who started their journey last fall. Our Community Super Users are the true heroes, answering questions, providing solutions, filtering spam, and so much more. The impact they make on the Communities each day is significant, and we wanted to do something special to welcome them at our first kickoff meeting of the year.   Charles Lamanna, Microsoft CVP of Business Applications, has stressed frequently how valuable our Community is to the growth and potential of Power Platform, and we are honored to share this message from him to our 2024 Season One Super Users--as well as anyone who might be interested in joining this elite group of Community members.     If you want to know more about Super Users, check out these posts for more information today:    Power Apps: What is A Super User? - Power Platform CommunityPower Automate: What is A Super User? - Power Platform Community Copilot Studio: What is A Super User? - Power Platform Community Power Pages: What is A Super User? - Power Platform Community

February 2024 User Group Update: Welcoming New Groups and Highlighting Upcoming Events

It's a new month and a brand-new year, which means another opportunity to celebrate our amazing User Groups!Each month, we highlight the new User Groups that have joined the community. It's been a busy season for new groups, because we are thrilled to welcome 15 New User Groups! Take a look at the list below, shared by the different community categories. If your group is listed here, give this post a kudo so we can celebrate with you!   We love our User Groups and the difference they make in the lives of our Community! Thank you to all the new User Groups, new User Group leaders--we look forward to hearing about your successes and the impact you will leave!   In addition to our monthly User Group spotlight, it's a great time to share some of the latest events happening in our User Group community! Take a look at the list below to find one that fits your schedule and need! There's a great combination of in-person and virtual events to choose from. Also, don't forget to review the many events happening near you or virtually! It's a great time of year to connect and engage with User Groups both locally and online. Please Welcome Our NEW User Groups   Power Platform: Heathcare Power Platform User Group Power Platform Connect Hub Power Platform Usergroup Denmark Mexico Norte- Power Platform User Group Pune Power User Group Sudbury Power Platform User GroupMicrosoft User Group GhanaMPPBLR - Microsoft Power Platform Bengaluru User Group Power Apps:   Myrtle Beach Power Platform User GroupAnanseTechWB PowerApps Copilot Studio: Pathfinders Power Platform Community Dynamics365: Cairo, Egypt MSD 365 Business Central/NAV/F&O User GruopMS Dynamics 365 Business Central LatamCincinnati OH D365 F&O User Group February User Group Events February 2024 Cleveland Power Platform User GroupPortallunsj - Februar 2024Indiana D365/AX February User Group MeetingQ1 2024 KC Power Platform and Dynamics 365 CRM Users Group 

January 2024 Community Newsletter

Welcome to our January Newsletter, where we highlight the latest news, product releases, upcoming events, and the amazing work of our outstanding Community members. If you're new to the Community, please make sure to follow the latest News & Announcements in each Community and check out the Community on LinkedIn as well! It's the best way to stay up-to-date in 2024 with all the news from across Microsoft Power Platform and beyond.      COMMUNITY HIGHLIGHTS Check out the most active community members of the last month! These hardworking members are posting regularly, answering questions, giving (and receiving!) kudos, and consistently providing top solutions in their communities. We are so thankful for each of you--keep up the great work! If you hope to see your name here next month, make it your New Year's Resolution to be more active in the community in 2024.   Power AppsPower AutomateCopilot StudioPower PagesWarrenBelzWarrenBelzPstork1saudali_25LaurensMPstork1stephenrobertLucas001AARON_ClbendincpaytonSurendran_RANBNived_NambiarMariamPaulachanNikhil2JmanriqueriosANBJupyter123rodger-stmmbr1606Agniusstevesmith27mandelaPhineastrice602AnnaMoyalanOOlashynBCLS776grantjenkinsExpiscornovusJcookSpongYeAARON_CManishSolankiapangelesPstork1ManishSolankiSanju1Fubar   LATEST NEWS Power Platform 2024 Release Wave Highlights This month saw the 2024 Release Wave 1 plans for Microsoft Power Platform and Microsoft Dynamics 365- a compilation of new capabilities planned for release between April and September 2024. Click here to read Corporate Vice President Maureen (Mo) Osborne's detailed breakdown of the upcoming capabilities, and click the image below to check out some of the Power Platform 2024 Release Wave 1 highlights.     "What's New" Power Platform Shorts Series This month we also launched our brand-new 'Power Shorts' series on YouTube - a selection of super sweet snapshots to keep you in the loop with all the latest trends from across the Power Platform and beyond. Click the image below to check out the entire playlist so far, and don't forget to subscribe to our YouTube channel for all the latest updates.   Super User In Training (S.U.I.T) It was great to see the Power Platform Community officially kick off Season One of their Super User in Training (SUIT) program this month! Their first meeting saw an amazing turnout of over 300 enthusiastic participants who started their dynamic journey toward becoming Super Users. Huge thanks to Manas Maheshwari, Eric Archer, Heather Hernandez, and Duane Montague for a fantastic kick-off. The first meeting also saw seasoned Super User, Drew Poggemann, share invaluable insights on navigating the #MicrosoftCommunity with finesse. Many thanks to Drew for setting the stage and emphasizing the importance of active engagement and the art of providing thoughtful community solutions. If you want to learn more about the features and benefits of gaining Super User status, click the image below to find out more, and watch this space for more info about Season Two and how you can SUIT UP in the community!     UPCOMING EVENTS Microsoft 365 Community Day - Miami - February 1-2, 2024 It's not long now until the Microsoft 365 Community Day Miami, which will be taking place at the Wolfson Campus at Miami Dade College on 1-2 Feb. 2024. This free event is all about unlocking the full potential of Power Platform, Microsoft 365, and AI, so whether you’re a tech enthusiast, a business owner, or just curious about the latest Microsoft advancements, #M365Miami is for you.   The event is completely free and there will sessions in both English and Spanish to celebrate the vibrant and diverse make-up of our amazing community. Click the image below to join this amazing Community Day in Miami and become a part of our incredible network of learners and innovators!     Microsoft Fabric - Las Vegas - March 26-28, 2024 Exciting times ahead for the inaugural #MicrosoftFabric Community Conference on March 26-28 at the MGM Grand in Las Vegas. And if you book now, you can save $100 off registration! The Microsoft Fabric Conference will cover all the latest in analytics, AI, databases, and governance across 150+ sessions.   There will be a special Community Lounge onsite, interactive learning labs, plus you'll be able to 'Ask the Experts' all your questions to get help from data, analytics, and AI specialists, including community members and the Fabric Customer Advisory Team. Just add the code MSCUST when registering for a $100 discount today. Click the image below to find out more about the ultimate learning event for Microsoft Fabric!     Microsoft 365 Conference - Orlando - April 30 - May 2, 2024 Have you added The Microsoft 365 Conference to your community calendar yet? It happens this April 30th - May 2nd in Orlando, Florida. The 2024 Microsoft 365 Conference is one of the world’s largest gatherings of Microsoft engineers and community, with a strong focus on Power Platform, SharePoint, Azure, and the transition to an AI-powered modern workplace.   Click the image link below to find out more and be prepared to be enlightened, educated, and inspired at #M365Conf24!   LATEST COMMUNITY BLOG ARTICLES Power Apps Community Blog Power Automate Community Blog Copilot Studio Community Blog Power Pages Community Blog Check out 'Using the Community' for more helpful tips and information: Power Apps, Power Automate, Copilot Studio, Power Pages  

Super Users 2024 Season One is Here!

   We are excited to announce the first season of our 2024 Super Users is here! Our kickoff to the new year welcomes many returning Super Users and several new faces, and it's always exciting to see the impact these incredible individuals will have on the Community in 2024! We are so grateful for the daily difference they make in the Community already and know they will keep staying engaged and excited for all that will happen this year.   How to Spot a Super User in the Community:Have you ever written a post or asked for help in the Community and had it answered by a user with the Super User icon next to their name? It means you have found the actual, real-life superheroes of the Power Platform Community! Super Users are our heroes because of the way they consistently make a difference in the Community. Our amazing Super Users help keep the Community a safe place by flagging spam and letting the Community Managers know about issues. They also make the Community a great place to find answers, because they are often the first to offer solutions and get clarity on questions. Finally, Super Users share valuable insights on ways to keep the Community growing, engaging, and looking ahead!We are honored to reveal the new badges for this season of Super Users! Congratulations to all the new and returning Super Users!     To better answer the question "What is a Super User?" please check out this article: Power Apps: What is A Super User? - Power Platform CommunityPower Automate: What is A Super User? - Power Platform Community Copilot Studio: What is A Super User? - Power Platform Community Power Pages: What is A Super User? - Power Platform Community

Did You Attend the Microsoft Power Platform Conference in 2022 or 2023? Claim Your Badge Today!

If you were one of the thousands of people who joined us at the first #MPPC Microsoft Power Platform Conference in 2022 in Orlando--or attended the second-annual conference in Las Vegas in 2023--we are excited to honor you with a special community badge! Show your support for #MPPC Microsoft Power Platform Conference this year by claiming your badge!           Just follow this link to claim your badge for attending #MPPC in 2022 and/or 2023: MPPCBadgeRequest    Want to earn your badge for 2024? Just keep watching our News & Announcements for the latest updates on #MPPC24.

Users online (4,487)