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 Apps / How to check if item a...
Power Apps
Answered

How to check if item already exists in SharePoint list with latest status

(0) ShareShare
ReportReport
Posted on by 194

Hello All,

 

I'm using SharePoint + PowerApps 

I have the following scenario in my list:
Share Point List Name: "Project Update"

 

Below are two columns which I have in my SP list. 

1.PNG

 

Now In my Power Apps I have one screen which contain Drop down Project Name.

 

2.PNG

 

Requirement: 

When I select project name in dropdown (like I selected "ABC" for project name)...So I wants to know last Project Status in "Last Status" text box from my share point list.

 

Like for a now in Powerapps I selected "ABC" as Property Name, then it should check in share point list and give me the latest's status of "ABC" property.

 

So for above scenario "Last status" text box value should be "International hold".

 

Can anyone help me for the syntax of "last status" text box?

 

Categories:
  • Verified answer
    CU-18081211-6 Profile Picture
    9,272 Moderator on at

    Hi @Viral21,

     

    Use in LastStatus Default property of  InputText(if is a InputText control) or Text property (is a Label control ) :

    Last(Filter('Project Update','Project Name' = TheNameOfYourDropDownforProjectName.Selected.Value)).'Project Status'

     

    Hope it helps !

  • Viral21 Profile Picture
    194 on at

    Thank you so much Gabibalaban for your quick help.
    -Viral Patel

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 Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 432 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 347

#3
WarrenBelz Profile Picture

WarrenBelz 254 Most Valuable Professional

Last 30 days Overall leaderboard