web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Clear Lookup Column re...

Power Apps

Answered

Clear Lookup Column reference using Power Fx Commands

(0) Share

Report

Report

Posted on by David Pezzoli

230

Hi all,

about new Command Apps (Customization Buttons), I need a button able to clear (set null) a lookup field.

https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/commanding-use-powerfx

How can I do it using the Power Fx commands? Note: I don't want to use JavaScript.

My first tentative was this expression:

Patch(Leads,Self.Selected.Item,{'Lookup Column': Blank()});

but the Blank() command doesn't work: no reference item clear (it tested it after publishing all customizations).

Unfortunately, there is no Null() function like in Power Automate.

David

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @David_Pezzoli :

The key is that under normal circumstances, such formulas cannot take effect in Canvas (Usually Blank() cannot be used to update a field).

You could try Unrelate in stead of Patch:

I assume there are Two Tables Releatedtable and ThisTable,the relationship between this two tables is 1:M.And then you could set the Commands in the "ThisTable":

For example:

Unrelate( LookUp(ReleatedTable,Name=Self.Selected.Item.ReleatedTable.Name).ThisTable, Self.Selected.Item )

I think this link will help you a lot:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-relate-unrelate

Best Regards,

Bof

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @David_Pezzoli :

Power Fx Command is a preview function, so I suggest you use the solution that wants to be more stable JS way:

JS code:

function test(primaryControl) { primaryControl.getAttribute("FieldName").setValue(null) }

Add Parmeter

Best Regards,

Bof

Was this reply helpful? Yes No

Join the conversation