Unanswered

Trying to add a column from another list to my dataset

(0) Share

Report

Posted on by bobgodin

380

I am trying to use AddColumns to add a field to the Claims list called wma (Choice field in Sharepoint) from the Events list to create a collection - my code is:

it is giving me an error "The requested operation is invalid. Server response - Events failed. The field in Events is called theeventID and the field in Claims is eventID and they should match - I need to get the wma value from Events into my collection colClaims

thanks for any assistance!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

abc 123 784 Moderator on at

Like (0)

Report

Assuming that you only want to return one column from the Lookup, then it should be in this syntax format:

Lookup([ListName], [Criteria]).FieldNameToReturn

Where the dot FieldnameToReturn is hanging off the outside of the Function() parens.

Was this reply helpful? Yes No
ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (0)

Report

Why are you using wma.value? You can probably change it to wma if wma is a column name.

Was this reply helpful? Yes No
WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report
Hi @bobgodin

Try with a disambiguation operator - I assume wma is a Choice or Lookup column.
ClearCollect( colClaims, AddColumns( Claims, thewma, LookUp( Events As _E, _E.theeventID = eventID ).wma.Value ) ); Set( varWait, false );

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report

@bobgodin

A quick follow-up to see if you received the answer you were looking for or if you need further assistance. I believe from a subsequent post that wma is a Choice field.

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No