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 / Checking name is alrea...
Power Apps
Unanswered

Checking name is already exist in DB

(0) ShareShare
ReportReport
Posted on by

Hi ,

 

Suppose I am using text input and enter country name(INDIA) and it updated on my sharepoint but at next time if I am usine county name (india) . This also update on sharepoint . I want to comparison between two string and dont want to update same country name either it is in lowercase or upper case. 

 

 

Can anybody having idea ?

 

Thanks,

Chitrakant27

Categories:
I have the same question (0)
  • Sundeep_Malik Profile Picture
    6,484 on at

    Hey @Chitrakant27 

     

    You can put a validation on it. 

    Check out the previous post for more information:

    https://powerusers.microsoft.com/t5/Building-Power-Apps/Validate-input-text-is-exists-in-the-table/td-p/366829

    https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-check-if-item-already-exists-in-SharePoint-custom-list/td-p/212785

     

    And for the form you can use Proper function, so that whenever the user inputs something, it will always become in a certain format. 

    Like if he inputs India, like INdia, INDIA, india, it will always be converted to India.

    To read more about proper function, check out the following link:

    https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-lower-upper-proper

     

     

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 759 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 310 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 228

Last 30 days Overall leaderboard