How to remove a record for a table inside a collection

(0) Share

Report

Posted on by FlorentGiboin

Hello,

I have a table in a collection. I need to remove a record a that table. Any ideas ?

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

AJ_Z 3,711 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You can use the Remove function or RemoveIf function where applicable.

do you have some screenshots or details of the Power Fx Formula you are using?

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

Was this reply helpful? Yes No
FlorentGiboin 29 on at

Like (0)

Report
Copy link

Link copied!
Ok, I know how to remove works but :
In know the Remove function ^^
Remove( lookup(Collection,id=1).myTable, //I select the collection record and table where I want to remove a record ....... // How to remove now ?

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @FlorentGiboin,

Did you solve your issue?

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @FlorentGiboin :

Do you want to remove the record whose id is 1 from the collection? If so, please try:

RemoveIf(Collection,id=1)

Best Regards,

Bof

Was this reply helpful? Yes No
FlorentGiboin 29 on at

Like (0)

Report
Copy link

Link copied!

I want to remove a record of a table INSIDE a collection. Not remove a record of a collection.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @FlorentGiboin :

Is it possible to provide the data structure of the data source? Is it possible to provide a demo?

Could you describe in detail the rules for deletion?
Best Regards,

Bof

Was this reply helpful? Yes No
FlorentGiboin 29 on at

Like (0)

Report
Copy link

Link copied!
ClearCollect(tempTableText,{_alpha:"",_beta:"",_delta:"",_epsilon:"",_gamma:"",_lambad:"",_mu:"",_zeta:""});Clear(tempTableText); ClearCollect(tempParams,{id:0,Input:"",inputDisplay:"",ShortName:"",Name:""}); Clear(tempParams); ClearCollect(vFormMass,AddColumns( SortByColumns(Filter(ChoiceForms,Requestable.Name=vRequested),"dp_order",Ascending) ,"input","" ,"inputDisplay","" ,"inputPicker2",tempPerson2 //,"inputPickers2",tempMultiplePicker ,"inputTable",tempTableText ,"myToggle",false ,"isVisible",If(IsBlank(ThisRecord.ParentTagOrder),true,false) ,"isValid",If(!IsBlank(ThisRecord.isOptional),false,true) ,"isSaved",false ,"inputParams",tempParams ) // End AddColumns ); // End Collect
How to do a remove in vFormMass a record of inputTable ?

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @FlorentGiboin :

Do you want to remove a record in the table type field inputTable of a specific record in vFormMass?If so , there is currently no such an OOB function to achieve this requirement. But there is a work around:

First find the inputTable in the specified record, filter it and save it to a temporary variable, and then overwrite the original inputTable value with this new value

I assume you want o delete the record whose id=1 in inputTable of the first record in vFormMass.

With( {NewTable:Filter(First(vFormMass).inputTable,id <> 1)}, Patch(vFormMass,First(vFormMass),{inputTable:NewTable}) )

Best Regards,

Bof

Was this reply helpful? Yes No
FlorentGiboin 29 on at

Like (0)

Report
Copy link

Link copied!

I was using a temporary table but can play with collect in a ForAll, but why I didn't think to use a WITH as you proposed !!!!!
Thank you !

Was this reply helpful? Yes No