Unanswered

Want to add new Item in gallery Item (backend : Sharepoint List)

(0) Share

Report

Posted on by sachinsoni

Hello,

I want to add new item in powerapps gallery, but i want if particular item is already exists in gallery, then show error message you cant add new item, beacuse item is already exists.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Mike8 1,330 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

Can you use this as a reference?
- Button1.OnSelect = ClearCollect(ColItems,{ItemName:"Item1"},{ItemName:"Item2"},{ItemName:"Item3"},{ItemName:"Item4"})
- TextInput1 (to add new records)
- Button2.OnSelect = If(LookUp(ColItems,ItemName=TextInput1.Text,true),
Notify("The item "&TextInput1.Text&" already exists",NotificationType.Warning),
Collect(ColItems,{ItemName:TextInput1.Text}))
- Gallery1.Items = ColItems

If you type Item5 in the TextInput1 and press Button2, you can see the item in the gallery. If you try to do the same you will see a warning message because Item5 already exists. Hope this helps

Was this reply helpful? Yes No
sachinsoni 51 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Sir,

That is my complete scenario.
I have to column in sharepoint list first column type is person and second column type is person or group, I want when i submit the form, i want to check person already exists or not. both field type is person and group but first is only person.

Was this reply helpful? Yes No
Mike8 1,330 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello Sir 🙂

You can try to do a LookUp like this one:
LookUp(ColItems,ItemName=TextInput1.Text,true)
as a condition in an If statement.
ColItems is the table you want to check if the new item exists
ItemName is the Column in the table you want to check if the new item exists
TextInput1.Text is the input of the user. The new Item that is about to be added or not
true is returned if the condition ItemName=TextInput1.Text is met.
Check the Button2.OnSelect expression and maybe try to recreate the example on the previous post. It can help you to find a solution for your issue

Was this reply helpful? Yes No
sachinsoni 51 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Sir..

Please Check

Was this reply helpful? Yes No
Mike8 1,330 on at

Like
a
(1)

Report
Copy link

Link copied!

Can you try if this works?

If(LookUp(EmpAndApprover,Approver=DatacardValue11,true),
Notify("The item "&DatacardValue11&" already exists",NotificationType.Warning),
SubmitForm(Form2);Navigate(AdminDashboard,ScreenTransition.Fade);Refresh(EmpAndApprover))

Was this reply helpful? Yes No
sachinsoni 51 on at

Like
a
(0)

Report
Copy link

Link copied!

Still facing error... Invalid argument type.

Was this reply helpful? Yes No