Unanswered

Set Lookup Field in Sharepoint to Blank

(0) Share

Report

Posted on by wuffwuff2004

Hello,

I have a Lookupfield in a sharepoint list. In powerapps, I have a dropdown, now I set the dropdown to value and save the Form. All ok, but now I want to have a button, when I click this button i will that in my sharepoint lookupcolumn this entry will be deleted, same as I go to sharepoint and delete this item manually . So I used this code :

Patch(Liste_Personal; LookUp(Liste_Personal; ID = Value(DataCardValue518.Text)); {fk_per_pc_emprunte: Blank()});;

No error on the code, but m in my Sharepoint list , what do I do wrong? Thanks

Screenshot 2024-05-03 164801.png

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @wuffwuff2004

The Blank() function is used to represent a blank value for text fields, but for a Lookup field, you need to set it to null by using a record with a Value field set to null.

Patch(
Liste_Personal,
LookUp(Liste_Personal, ID = Value(DataCardValue518.Text)),
{fk_per_pc_emprunte: {Value: Blank()}}
);

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
wuffwuff2004 33 on at

Like (0)

Report
Copy link

Link copied!

Hello, I tried exactly this but this gives me the following error (I try to translate correctely):
"Wrong argument. It is needed an other record type with an other schema. In your formula is missing a column Id from type NUMBER"
Many thanks

Was this reply helpful? Yes No
Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!
Try this formula,

Patch(
Liste_Personal,
LookUp(Liste_Personal, ID = Value(DataCardValue518.Text)),
{
ID: Value(DataCardValue518.Text), // Ensure this matches the column name and type in your data source
fk_per_pc_emprunte: {Value: Blank()}
}
)

(Or)

Patch(
Liste_Personal,
LookUp(Liste_Personal, ID = Value(DataCardValue518.Text)),
{
ID: Value(DataCardValue518.Text),
fk_per_pc_emprunte: Blank()
}
);

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
wuffwuff2004 33 on at

Like (0)

Report
Copy link

Link copied!

Hi, Many thanks, the first one gives me the same error, the second one doesn't give me an error instead it won't remove the entry in my Sharepoint List.
Best regards

Was this reply helpful? Yes No