Date data type removal from the gallery

(1) Share

Report

Posted on by AA-13081012-0

Hi,

The purpose of this code is to remove a client and its start date from the table (I am connected to the SQL server).

There is an error with the SelectedDate data type: "Incompatible type. The collection can't contain values of this type." I've tried to cast this Date type to Text, but there is an error that the function expects here date type of data and not text.. It makes no sense.

Do you have any ideas of how to fix it?

Remove(
    'TABLE',
    Gallery_MY_GALLERY,
    {
    CLIENT_NAME: If(IsBlank(DataCard_Value_CLIENT_NAME.Text), Blank(), DataCard_Value_CLIENT_NAME.Text),
    START_DATE: If(IsBlank(DateValue.SelectedDate), Blank(), DateValue.SelectedDate)
    }
    );
Set(
    VarShowPopup,
    false
);
Navigate('HOME SCREEN'); Notify("Record deleted successfully", NotificationType.Success)
 
CLIENT_NAME is text input card type.
START_DATE is a date picker card type.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

abc 123 789 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!

The Remove() function removes (deletes) a row from a collection or list, not reset individual columns. RemoveIf, too.

If you want to update the columns, then use the Update or UpdateIf function.

Update and UpdateIf functions - Power Platform | Microsoft Learn

Use the IfError() function to trap for errors.

UpdateContext({strErrMsg: "None"});

IfError(

[Try to do something],

UpdateContext({strErrMsg: FirstError.Message})

);

If(strErrMsg = "None" ,

Notify("Something happened correctly, for once.");

Navigate(scrnAnotherScreen)

,

Notify("Something didn't happen correctly, again. Error: " & strErrMsg)

)

Was this reply helpful? Yes No
AA-13081012-0 11 on at

Like
a
(0)

Report
Copy link

Link copied!

@abc 123 thanks for the answer. I used the Remove function before for other tables with text input only fields - it worked, the records were deleted immediately. I need to do the same for this table - I need to remove a client and its starting date from the table, but the issue is Date data type. Can you please help with this?

Was this reply helpful? Yes No
timl 37,248 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
Can you clarify what DataCard_Value_CLIENT_NAME and DateValue are? Are these both controls on a Form control?

If you want to remove all records where Client_Name matches the value in DataCard_Value_CLIENT_NAME and START_DATE matches the value in the DateValue picker, the syntax you would use is this:

RemoveIf( 'TABLE', CLIENT_NAME = DataCard_Value_CLIENT_NAME.Text && START_DATE DateValue.SelectedDate )

Was this reply helpful? Yes No
abc 123 789 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Wheneven I use the Remove, (I actually use RemoveIf()), I base it on the ID or something else unique.

RemoveIf(ListName, ID=intIDtoRemove);

I don't understand why you need to remove individual columns when you want to delete the entire item. Just delete the item and be done with it.

Was this reply helpful? Yes No
AA-13081012-0 11 on at

Like
a
(0)

Report
Copy link

Link copied!

@timl it worked!! thank you so much

Was this reply helpful? Yes No