web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Lookup Function : find...

Power Apps

Unanswered

Lookup Function : find number value from Excel sheet and populate into Sharepoint List

(0) Share

Report

Report

Posted on by Justjay6

2

Hello,

I have an Excel table (SKU_List) linked with a column with number formatting called SKU_Code (where data needs to be found)

I have created a number column on Sharepoint List called SKUNumber (where I need data to be stored)

On the powerapps forms, i have inserted the SKUNumber Datacard and for OnSelect, inserted below formula

LookUp(SKU_List, SKU_Code=Value(DataCardValue17.Text).SKU_Code)

I keep getting "Incompatible types for comparison: These types can't be compared: Number, Error'

Any help?

My purpose is to be able to use the excel column to lookup a value and save it on Sharepoint list

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

WarrenBelz 155,300 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Justjay6 ,

Where are you putting that code ? If on the Item of a form, you need a record -

LookUp( SKU_List, SKU_Code = Value(DataCardValue17.Text) )

also the field may be Text

LookUp( SKU_List, SKU_Code = DataCardValue17.Text )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
WarrenBelz 155,300 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Justjay6 ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Justjay6 2 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelzthanks for your help

I actually managed to fix it somehow - believe changing the last fullstop before SKU_Code to comma did the trick

Was this reply helpful? Yes No

Join the conversation