Answered

Lookup SP list to see if item with same name and a certain status exists

(0) Share

Report

Posted on by RST101

Hello,

I have a canvas app that is used to create Document Change Requests. All change request are stored in a SharePoint list. When using the app to create a new change request, The app can tell a user if a change for the document they have selected is already in the list. This is to stop users logging duplicate requests. However, I need to be able to add a condition to the lookup that checks the status column (status is a choice column in the SharePoint list) and only notifies the user that there is an item if the status is not 'Change Completed' or 'Rejected'

Here is the formula now that notifies the user regardless of status:

If(!IsBlank(LookUp('Technical Change Requests','DocChange Name'=DataCardValue1.Text)),Notify("There is already a pending change for this document",ErrorSeverity.Warning,0)

What do I need to do to add the condition regarding the status?

Thank you in advance,

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@RST101

With({_items: Filter('Technical Change Requests', Status.Value<>"Change Completed"||"Rejected") }, If( !IsBlank( Lookup( _items,'DocChange Name' = DataCardValue1.Text ) ),Notify("There is already a pending change for this Document",NotificationType.Error, 0) ) )

I am curious about your "ErrorSeverity.Warning," I have never seen this as part of a Notify function.
RST101 15 on at

Like
a
(0)

Report
Copy link

Link copied!

ErrorSeverity.Warning is used to display a Yellow Warning banner rather than a red(stop) error banner when using Notify.

I am afraid your formula is not working - I am not getting any errors but its still showing me the notify when adding items with the same DocChange Name and a status of ''Change Completed'' or ''Rejected''

Do you have any other suggestions on this?
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@RST101

Thanks so much for the info on ErrorSeverity

Do you want to provide the Notification if the entry is already listed as "Change Completed" or "Rejected" in your table? If so, change the "<>" to "=".
RST101 15 on at

Like
a
(0)

Report
Copy link

Link copied!

I do not want to provide the Notification if the entry is already listed as ''Change Completed'' or ''Rejected''

The Notification should only show if the document name already exists in the list (covered by my formula) and if status of that item is ''Pending Approval'' or ''Approved''

I hope this helps - Please let me know if I can help with any more info I have been stuck on this for some time now so any help is appreciated 🙂

Thanks,
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@RST101

see above,I revised the post.

The initial filter should narrow the list to those who have status = completed' or 'rejected' and the lookup would tell if the person is in the list.
RST101 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much your solution has proven very useful and this is now working as expected!

Thanks Again!