web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps search if the element ...

Power Apps

Answered

search if the element exists if it exists notify if it does not exist create it

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Good afternoon,

Well I'm new to powerapps and I'm building an App, which works like this,

When the user creates the element, go to a sharepoint list and validate the ID number and if the element type that he chose already exists, if so, notify it and if it is not created, create it.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

cds 1,001 on at

Like
a
(1)

Report
Copy link

Link copied!

If(ID exactin Datasource.Column, Notify("This item exists", notification.information, 5000), false)
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

In operator is not suggested as it's not delegable for sharepoint.

I would recommend you use IsBlank() & LookUp() function to check there are any records with this element.

If( IsBlank(LookUp('SP list', <ColumName>=<TheElement>).ID), Patch('SP list',Defaults('SP list'),{ <ColumName>:<TheElement>}), Notify("The element already exists!") )

For example:

If(

IsBlank(LookUp('SP list', Title=Textinput1.Text).ID),

Patch('SP list',Defaults('SP list'),{ Title:Textinput1.Text}),

Notify("The Title already exists!")

)

Hope this helps.

Sik

Join the conversation