Lookup and compare in Sharepoint Library

(0) Share

Report

Posted on by RaduR

Hello,

Can somebody help if is it possible to lookup and compare a value in a Sharepoint Document Library, not list.

I have in Powerapp a field where I introduce a value and I want to make it compare that value with values in column in order to notify in case it does exist.

I tried this, but I get an error.

If(
!IsBlank(
LookUp('Documente in Vigoare', 'Cod Intern' = Value(Self.Text))
),
Notify("This reference already exists", NotificationType.Error)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (1)

VasileR 298 Super User 2024 Season 1 on at

Like (0)

Report

Hei @RaduR ,

Add the If to the OnChange property of the Text control, and the "Behaviour ..." error will go away.

Was this reply helpful? Yes No
RaduR 64 on at

Like (0)

Report

I changed the idea by adding that value in a list so maybe it would be easier, in fact I got another error.

"
Concatenate(DepDoc.SelectedText.Value, " - ", TipDocum.SelectedText.Value, " - ", NrDoc.Text);
If(
!IsBlank(
LookUp('Codificare Interna', 'Title' = Value(Self.Text)).'Title')
,
Notify("This reference already exists", NotificationType.Error))"

It says "Incompatible types for comparison".

I don't know if i wrote something wrong or..

Was this reply helpful? Yes No
VasileR 298 Super User 2024 Season 1 on at

Like (0)

Report

Where did you add that code, and on what property?

Was this reply helpful? Yes No
RaduR 64 on at

Like (0)

Report

Is added on a Label. I need to concatenate 3 inputs into a label and verify if that label does exists in that ShrepointList.

Was this reply helpful? Yes No
VasileR 298 Super User 2024 Season 1 on at

Like (0)

Report

The label does not support behavior functions in the Text field (like Notify).
Either move the code to a button, or on one of the select steps (OnSelect for DepDoc or TipDocum).

Was this reply helpful? Yes No
RaduR 64 on at

Like (0)

Report

I switched to a button, but I get that error every time even if that value it does not exist.
I know "isBlank" is useless in this case, but I don't know how to reformulate the code for a button.
If(
!IsBlank(
LookUp('Codificare Interna', 'Title' = Value(ConcatenareCodDoc.Text))
),
Notify("This reference already exists", NotificationType.Error)
)

Was this reply helpful? Yes No
VasileR 298 Super User 2024 Season 1 on at

Like (0)

Report

You can remove Value() from the Concatenare, because you want to compare Text with Text.
Is 'Title' a text column in your library?

What is the error now?

Was this reply helpful? Yes No
RaduR 64 on at

Like (0)

Report

I tried without Value, but then the Label goes in Error.
Title is a column in List, I changed it now to "Codificare" as text column.
The button that check works kind of, but it always returns the error.

Was this reply helpful? Yes No
VasileR 298 Super User 2024 Season 1 on at

Like (0)

Report

Can you paste a value from the 'Codificare' column, so I can see what it contains?
I assume the label ConcatenareCodDoc is "0 - PL - 4214", right?

Was this reply helpful? Yes No
RaduR 64 on at

Like (0)

Report

Yes, that is the label.
In "Codificare" column I wrote exactly "0 - PL - 4214" so with the button I can check between column and label.
I also wrote 1 - PL - 4214 in the label, but it still shows the Error

Was this reply helpful? Yes No