Unable to lookup imported excel table to auto populate field in powerapp

(0) Share

Report

Posted on by nchandran

426

HI,

I have a powerapp where its two data sources are connected (sharepoint temp recording list & excel tabl1). In one field there is a user().email which auto populates whenever anyone login. This seats on DataCardValue16.

The idea is to have a field called GIN No(numeral type column) which should lookup the table1 using the input from datacardvalue16 find and locate the related number from the GIN colum from table1. Formula LookUp(Table1,Email=DataCardValue16.Text,GIN) doesnt populate anything on the desired GIN NO field. Refer to the screenshots.

Temp record Sharepoint list-> Sharepoint list.jpg

Table1 ->

Formula of the GIN NO field.

Formula doesnt work.jpg

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

eka24 20,923 on at

Like (0)

Report

Your formula looks fine but what is the ralationships between- sharepoint templist & excel tabl1.
What field can be found in both tables

LookUp(Table1,Email=DataCardValue16.Text,GIN)

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
nchandran 426 on at

Like (0)

Report

The sharepoint list is to store the user inputs and the table1 excel is to refer for the Gin number

So oh! we need to have similar field names? in that case i have renamed the excel field header to Name similar to sharepoint list as Full Name

Was this reply helpful? Yes No
Verified answer

eka24 20,923 on at

Like (0)

Report

Please it not about renaming, it about what the fact the both columns in the two tables should contain same information. For example if Table1 Email Contains "sss@mmm.com", Table 2 should have a column coantaing "sss@mmm.com". With this there would be a matching for the lookup.
Please the structure based on the dummy table 1 & 2:
In the DataCardValue16 that holds the logged in Email or Fullname from Table1: User().Email
OR User().FullName
Depending on what you want to use in Table1.

Then in the textbox for the Lookup to pick Gin put:
LookUp(Table1,Email=Datacarvalue16.Text,'Gin No')

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
nchandran 426 on at

Like (0)

Report

ok, i managed to get this working and understand what you are saying. The information from the table1 was from ldap and it didnt match the powerapps input because it was from 0365. after modifying the table1 selected email to the same as the input, it worked.

Was this reply helpful? Yes No