Remove with ForAll and Filter

(0) Share

Report

Posted on by Rob1990

Hi,

I have an app where if a radio box is checked questions that are stored in a Dataverse then get populated into another Dataverse table relating to that record.

On the flip side if the checkbox is unchecked the questions should then be removed, this is the part I'm having issues with.

I have used ForAll and filter and this is working for adding the questions, however when I try and remove the questions I can't seem to get this working. I have a many to 1 relationship from QuestionsTable to another table that stores the questions Sections

ForAll(Filter(QuestionsTable,'Section Title'.'Section Title'= "SectionA"),

RemoveIf(ProgressQuestionTable,'Site Name'.'Site Name'=VarCurrentSite.'Site Name' && 'Section Title'.'Section Title'="SectionA")
)

I'm sure my logic is wrong but can't seem to figure it out and I get the following error...

Not sure where I'm going wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

RogierE 875 Moderator on at

Like (0)

Report

I don’t recognize the error, but what I do know is that RemoveIf already removes all occurrences and the above code doesn’t change if you in every run of the ForAll.

Was this reply helpful? Yes No
Rob1990 42 on at

Like (0)

Report
@RogierE

Thanks for that manages to sort it by not using the filter and just handing it inside the 'RemoveIf'

ForAll(QuestionsTable, RemoveIf(ProgressQuestionTable,'Site Name'.'Site Name'=VarCurrentSite.'Site Name' && 'Section Title'.'Section Title'="SectionA") )

Was this reply helpful? Yes No