Error compatibility (GUID , Record)

(1) Share

Report

Posted on by gikido

1,032

Hi everyone;

I have two tables "Audit" and "Checklist" with relationship. The "checklist" table contains "IdAudit" and the unique identifier of the "Audit" table is "RecId". when I try this formula it gives me error of compatible type GUID and record and sign of delegation.

LookUp('Cheklist';Gallery1_3.Selected.'RecId '= IdAudit ; Bronze)

How can i solve this?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

LaurensM 12,516 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
@gikidolooking at the error, I expect IdAudit to be a record.
Is the RecId GUID field available in the record? If so, could you give this a try:

LookUp('Cheklist';Gallery1_3.Selected.'RecId '= IdAudit.'RecId' ; Bronze)
If your ID field within IdAudit has a different name, use this structure: IdAudit.IdFieldName.

Alternatively, if the Selected record is the same as IdAudit, you could try comparing records:

LookUp('Cheklist';Gallery1_3.Selected = IdAudit ; Bronze)

I hope this helps!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Filter('checklist','IdAudit.RecId=gallery_3.selected.'RecId';Bronze)

I hope this help

Was this reply helpful? Yes No
gikido 1,032 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous @LaurensM thank you it work now.

Another question plz
in the fonction Patch i have the same error {IdAudit : Gallery1.Selected.RecId}
How can i solve this?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

hi @gikido
can u share screenshot error in patch function?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

hi @gikido

Set(Approvedstatus,"Approved");
Set(Approvedstatus1,"pending");

Patch('checklist',LookUp('checklist,ID=Gallery1.Selected.RecId),{
IdAudit:Approvedstatus
});

Was this reply helpful? Yes No
gikido 1,032 on at

Like
a
(1)

Report
Copy link

Link copied!

I have 3 tables "Audit" and "Checklist" and "responses" with 2 relationship.
the Id of "Audit" is 'IdAudit' the Id of "Checklist" is 'IdChecklist' and the Id of the "response" table is Idreponses.
The "Responses" table contains the two table ids "Audit" and "Checklist".
when I try to fill the two Ids at the "answers" table level with the patch function as follows: {'IdAudit ': Gallery1_3.Selected.'IdAudit '} and {'IdChecklist ': Gallery1_3.Selected.'IdChecklist '} it gives me error: Record GUID not compatible

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @gikido

Set(
BeforeLeavebalance,
Gallery1_3.Selected.'IdAudit
);
Set(
BeforeLeaveApplied,
Gallery1_4.Selected.'IdChecklist
);

Patch(
Employesdetails,
{
ID: LookUp(
Employesdetails,
Title = User().FullName,
ID
),
Title: User().FullName,
Email: User().Email,
LeaveBalance: BeforeLeaveApplied,
LeaveAvailed: BeforeLeavebalance
}
);

Was this reply helpful? Yes No