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 / How to get only the va...
Power Automate
Answered

How to get only the value from a SharePoint list ?

(0) ShareShare
ReportReport
Posted on by 1,066
Hi,
I have a sharepoint list with just one column and just one value in it. I want to capture the value.
I made a variable to retrieve the value. But i get a whole lot of other data. How can i just retrieve
the value from the sharepoint list? 

Gr. P
Categories:
I have the same question (0)
  • omkar-godse Profile Picture
    22 on at
    Hi, are you trying to append that column value of all the items from your list into a variable? 
  • Verified answer
    creativeopinion Profile Picture
    10,508 Moderator on at
    @CU16021406-1 If you only want to return a single item—use the Get Item (singular) action. The Get Items action will return an array of items (even if it's just a single item).
     
    Also, since you are using an automated trigger in your flow, you may want to consider using trigger conditions. This way your flow will only trigger when you want it to instead of triggering each time and item or file is modified. Without trigger conditions your flow will trigger unnecessariliy. 
     
    If you aren't sure how to use trigger conditions in your flow, check out this YT Tutorial:
     
     
    Trigger conditions can be set in most flow triggers. These conditions you set must be true for the trigger to fire.
    In this Power Automate tutorial, I’m going to show you how to use trigger conditions in your flows to control when your Power Automate flows trigger. If your plan has flow run limits—you can avoid triggering your flows unnecessarily by using trigger conditions.
     
    I’ll cover four different flow examples that would benefit from trigger conditions:
    ⚡️ Triggering a flow when a column is changed to a specific value
    ⚡️ Triggering a Flow When an Event Updated or Deleted
    ⚡️ Triggering a Flow When a New Folder is Created
    ⚡️ Triggering a Flow When a Specific Email is Received
     
    I’ll also show you a trick on how to easily create the expressions needed and give you a few tips on how to troubleshoot your flow.
     
    IN THIS VIDEO:
    ✓ Four different flows that would benefit from trigger conditions
    ✓ What is a trigger condition?
    ✓ How to add a trigger condition to your flow
    ✓ How to trigger a flow when a column is changed to a specific value
    ✓ How to trigger a flow when an event is updated or Deleted
    ✓ How to trigger a flow when a new folder is created
    ✓ How to trigger a flow when a specific email is received
    ✓ How to troubleshoot a trigger condition
    ✓ How to prevent case sensitivity issues with a trigger condition
    ✓ How to use the filter array action to easily compose an expression that can be used in a trigger condition
     
    If you still run into issues while building your flow, share screenshots of your full flow and the logic behind it. Provide additional insights on what you are trying to accomplish.

    Upload a screenshot of your flow in edit mode. Ensure you click each action to expand it. 
     
    Hope this helps!

    Consider giving me a ❤️ if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 922

#2
Valantis Profile Picture

Valantis 837

#3
Haque Profile Picture

Haque 534

Last 30 days Overall leaderboard