patch to sharepoint list with lookup column

(0) Share

Report

Posted on by ashwagamz

Hi there,

I have two lists in SharePoint and there is a relationship between list A and List B.
List B has a lookup column.

Idea_Id is a lookup column in list B and the type of idea_Id is an ID from list A, I want to add new data to list B if this data does not exist. So, I type the code below to check if data already exists

If(IsBlank(LookUp('Votes-Details_2',Idea_ID = ThisItem.ID)),
Set(varLoad,true); 
Patch(
 'Votes-Details_2',
 {
 Ideas_Id: Gallery3_3.Selected.ID, Title:Gallery3_3.Selected.Title
 }
);
Set(varLoad,false);,false)

but I have an error when checking if data already exists, the error is :

incompatible types for comparison, These types cant be compared: Record, text

Also, I can't add data to Idea_Id using the patch function, the error is :

the type of this argument does not match the expected type Record

Categories:

Building Power Apps

All responses (1)

Answers (0)

WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@ashwagamz ,

You have three posts on the same subject - I have responded to one here