Lookup Field from SharePoint list does not show value.

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

There is a Text Label that shows lookup value from SharePoint list. This Label text is set ThisItem.'Department_x002f_Division'.Value and work normally. However, it suddenly stops working. The Text Label shows error as bellow:

name isn't valid. this identifier is not recognized.

If I change ThisItem.'Department_x002f_Division'.Value to ThisItem.'Department_x002f_Division'.Id, it will works and show Id Of Lookup field.

I have already check that I do not lookup to LinkToItem value, and no additional value from Lookup column. Also, I remove gallery and start from scratch without success.

Please let me know this kind of issue.

Thanks for reading!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Is there any experts here to help me?

Thanks for reading.

Was this reply helpful? Yes No
asfd 9 on at

Like (0)

Report
Copy link

Link copied!
I have the same issue - I'm using "Concat" function, but it does not work... It says that "Name isn't valid. Value isn't recognized"

Concat( mySharePointItem.myLookupColumn, Value, ";" )

However it works for another Lookup column, just this one is not working for some reason. Changing "Value" to "Id" make no difference.

Was this reply helpful? Yes No
Suggested answer

Nandit 1,568 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi there,

Can you try replacing ThisItem.'Department_x002f_Division'.Value with ThisItem.'Department Division'.Value.

I am assuming in your SP list the column name is 'Department Division'.

There is no need to substitute space with _x002f_.

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No