Answered

Stuck with LookUp() - Cannot Reference a Dataverse lookup column?

(0) Share

Report

Posted on by djworsdell

Hello all,

I am running into a metaphorical brick wall regarding the LookUp() function with reference to lookup columns in Dataverse. There are two tables, 'tools' and 'actions', and I want to pick out the last action for that specific tool. A One-to-Many relationship has already been set up between 'tools' and 'actions'...

tools
tool_id	Primary ID (Auto #)
ranking	Choice
text	Text

actions
action_id	Primary ID (Auto #)
tool	Lookup (tool_id)
status	Choice

Here's a snippet of the code I'm currently working with... Power Apps indicates that "LookUp has invalid arguments", but this is the format I've taken out of the documentation and have used with success in previous applications.

ClearCollect(data,
    AddColumns(
        // Get 'tools' table
        tools,
  
        // Identify last status from 'action'
        "status",
            LookUp(Sort(actions, createdon, Descending), cr979_toolsid = tool, status)
    )
);

Any ideas/suggestions would be greatly appreciated! If there's an alternative to LookUp() I'd also be very happy to hear them!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Manan-Malhotra 621 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
ClearCollect(data, AddColumns( // Get 'tools' table tools, // Identify last status from 'action' "status", LookUp(Sort(actions, createdon, Descending), cr979_toolsid = tool). status ) );
I am not sure why was "tool, status" used, were you trying to return status, if yes use the following code

Was this reply helpful? Yes No
djworsdell 75 on at

Like (0)

Report
Copy link

Link copied!

@Manan-Malhotra wrote:
I am not sure why was "tool, status" used, were you trying to return status, if yes use the following code
Thanks Manan - now I've encountered an "AddColumns has some invalid arguments", and underlines the entire section red. Completly at a loss as I haven't seen this behaviour before...

Was this reply helpful? Yes No
Manan-Malhotra 621 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Then I am guessing the code written by you is correct just change the new column name from "status" to "someother name"

Also can you share the Screenshot of the error if it still exists

Was this reply helpful? Yes No
Verified answer

Manan-Malhotra 621 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hey, Actually your lookup isn't reading the table name "action"
Try using "[@action]" this way

Please Accept as Solution if it solves your question Or just give it a Thumbs Up if it is helpful because this can help others.
LinkedIn: https://www.linkedin.com/in/manan-malhotra-vfx/
Want to support me! Buy me a Cup of Coffee?

Was this reply helpful? Yes No