Answered

Highlight if information is in SharePoint list already

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi folks, I have a query similar to vinimedina91's on How to check if item already exists in SharePoint', the difference being I just want something to appear if the text typed into an input box is already on the SP list. I've tried something simple on an icon's visibility:

If(phonenumber.Text in NO.Phoneno,true,false)

The app has taken it but I've typed in a number that's already saved and it's not shown.

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

rsaikrishna

3,703 on at

Like (1)

Report

Copy link

Link copied!

@Anonymous

In PhoneNumber control's onChange property,

Set(varShowIcon, If(self.Text in NO.Phoneno,true,false) )

Use the variable varShowIcon in the visible property of the Icon.

You need to set default value of the variable as false on screen load or app load.

Give a try and post your comments.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

On the Visible property of your Icon, set the following formula:

LookUp(yourDataSource, Phoneno = phoneNumber.Text, true)

I hope this is helpful for you.