Answered

Get Unique Identifier (ProjectGUID) out of global variable and save it with patch in LookupColumn

(0) Share

Report

Posted on by Marczii007

Hello everyone,

I have the following two tables. Projects and goals that have a one-to-many relationship. The Goals table has a lookup column "projects"

I would like to have the GUID of projects to be written into the respective goal column so that a goal can be assigned to a respective project.

I have saved the complete data set in a global variable. I dont know, how to get the GUID with the global Variable. However, this shows me the following error message:

Patch(
goals,
Defaults(goals), // new record
{
goaldescription: 'inp Step goals goalstep.Text,
projects: vprojects.ProjectGUID
}
);

"The type of this argument '...' does not match the expected type 'Record'. Found typ 'Guid'. The function 'patch' has some invalid arguments.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

charlessexton 21 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
I'll assume you're using Dataverse. In which case, you don't specify the GUID for the patch function, you specify the record.

Patch( goals, Defaults(goals), // new record { goaldescription: 'inp Step goals goalstep.Text, projects: vprojects } );

Was this reply helpful? Yes No
Marczii007 41 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the answer, it worked. But how do i get the GUID instead of the primary name column (ID in Projects)? 🙂

Was this reply helpful? Yes No
charlessexton 21 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
You'll have to check what it's called in your table, but generally it will be the singular form of the table name.

e.g.

First(projects).Project

Was this reply helpful? Yes No