Unanswered

Looking if ID matches in excel database

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am trying to navigate to another screen when the ticket id of a datacard matches one of the id's in my excel database.

If(IsBlank(LookUp(DataCardValue24.Text in MancoTabel.'Ticket ID'), Navigate([@Overzicht])))

This is the code that I thought of, sadly this does not work, who can help me?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

How about using something like this:

If(IsBlank(LookUp(MacoTabel, 'Ticket ID' = DataCardValue24.Text)), Navigate([@Overzicht]))

Assuming MacoTabel is the data source (excel table) and Ticlet ID is the column. Also not a 100% sure but depending on how that column is defined, you might have to use Value(DataCardValue24.Text) in the formula above to convert the string to a number/value.

Let me know if this helps.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your answer 🙂

If(IsBlank(LookUp(MancoTabel, 'Ticket ID' = DataCardValue24.Text)), Navigate([@Overzicht]))

This formula worked. How do I make it so it checks everything without the last one? Because when I now submit the ticket it will lookup the ticketID after submitting and then the ticket id will always be in there.

@PowerAddict

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Awesome! Do you mean you want to check the DataCardValue24 against the entire list not including the last record in the list?

Also, how many rows of data do you have or expect to have in your excel?

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, this is indeed true. I want to check every row except the last one. I can't say how many rows there will be, since it is a ticket system. @PowerAddict

Was this reply helpful? Yes No