Unable to fetch the data using Lookup function

(0) Share

Report

Posted on by nagaraj007

294

Hello All,

I am new to Powerapps, i have 2 datasources namely

1. ScanData1 : URN, InoutDate, User

2. Preregister : URN, CompanyName, Visitor Name

Both of them have URN as the common field.

I want to get the data from Preregister Database : CompanyName and VisitorName

Please advice how to go about this

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Try this:

LookUp('[dbo].[PreRegister]',urn=ThisItem.URN,CompanyName)

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

Was this reply helpful? Yes No
nagaraj007 294 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I am getting error as Invalid Argument Type near equal sign

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Two questions:
1. Is urn in the Table Preregister?
2. Is urn a number field? If so put: Value(ThisItem.URN)

Was this reply helpful? Yes No
nagaraj007 294 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
I was able to fix the issue. But however i am unable to save to the destination. Please find the attached error message.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Remove the Space in the "Company Name": CompanyName

Was this reply helpful? Yes No
nagaraj007 294 on at

Like
a
(0)

Report
Copy link

Link copied!

I get the error as

the specified column CompanyName doesn't exist.

My SQL Column has Company Name.

Please find the attached screenshot

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Put the Company Name in single quotes 'Company Name'

Was this reply helpful? Yes No
nagaraj007 294 on at

Like
a
(0)

Report
Copy link

Link copied!

I was able to save the data. But however the lookup works fine in the Powerapps, but when it goes to SQL it showing wrong numbers.

For ex: attached URN one is abc company and visitor name is nagaraj
and other is def company and visitor name is jagadeesh

But SQL shows both as nagaraj and abc company only.

Please advice. Attached is the SQL data

Was this reply helpful? Yes No
nagaraj007 294 on at

Like
a
(0)

Report
Copy link

Link copied!

And also when ever i scan and save it getting added into the main table also which is not required. Please find the attached screenshot of sql

Was this reply helpful? Yes No
nagaraj007 294 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Could you please help me on the issue. I have used lookup value from different table and saving all the fields to one table in SQL.
But the problem is Powerapps shows correct data once i scan it, however when i check in SQL table it shows wrong data.
I have attached 3 screensnips in one attachement.
One is formula of powerapps
two is main table from where the lookup is happening
third is the final data coming from powerapps.

Please advise.

Was this reply helpful? Yes No