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 Apps / Check if an item exist...
Power Apps
Unanswered

Check if an item exists in a SharePoint list

(0) ShareShare
ReportReport
Posted on by 141

Dears,

 

I have this SharePoint list, I need to check if the last record in Mix column exist already before in the list, so directly the LOETime should be updated in the last record to be 0.5

4.JPG

 

How I can achieve this. 

Thank You.

 

 

Categories:
I have the same question (0)
  • RandyHayes Profile Picture
    76,297 Super User 2024 Season 1 on at

    @GhassSD 

    LookUp(yourList, Mix="Power AutomatePower Virtual AgentSummarized", true)

    Will return true if the record that matches exists and false if not.

     

    I hope this is helpful for you.

  • GhassSD Profile Picture
    141 on at

    Dears,

    I tried it, but no success

    Any idea

    Thanks

  • RandyHayes Profile Picture
    76,297 Super User 2024 Season 1 on at

    @GhassSD 

    Can you provide more details on what you tried, where you tried it, and if there were errors, what they were?  Provide a screenshot if necessary to explain further.

  • RichardHorvath Profile Picture
    14 on at

    ***I see this is an old question, but doesn't have a fully working answer yet.***

     

    The logic behind finding whether a new item is there or not is to filter your list to the "new or not" value and count the matches. If the count is 0, it's a new value, if it isn't, it is an already existing one.

     

    So in general it looks a bit like this:

     

    If(CountRows(LookUp(YourList, ColumnName=EntryToBeExamined)) > 0, true, false)

    Your question being "Is it an existing value?"  or "Do I need to update LOETime?". Then write your next action in the true branch, and if there is nothing to do with the false, you can skip it.

     

    In your case,
    YourList is the SharePoint list you use,
    ColumnName is "Mix",
    EntryToBeExamined is either from a variable, or the source of input field on your form, textbox, dropdown, etc. But it's very important to be an exact match, otherwise you'll have to complicate with putting both phrases you are matching all Lowercase or Uppercase for example.

     

    This determines, whether the value is new or not. With the above case, your true value is, when the value already exists, and you want to update the LOETime to 0.5 seconds.

     

    If it makes more sense to you, to turn the true/false result around, you can always check, whether the count equals to zero, that way, you're checking whether there isn't any matching results. So in this case you basically ask the question: "Is this a new value?".

    In this case, you'd have to do the LOETime setting in the false branch...

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 Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard