Answered

Where clause equivalent in Power Apps for Filter

(0) Share

Report

Posted on by krickard

124

I'm struggling with attempting to write the PA equivalent of a SQL where clause. In this Bold line below I want to flag records to be deleted in TempOptions that have the same QID as a parent record in TempQuestions that has already been marked with the delete flag. PA doesn't like using Filter with =.

Is there a way to filter the multiple records in TempOptions and flag them based on the matching the QID and delete flag from another table (TempQuestions)?

Patch(TempQuestions, LookUp(TempQuestions, QuestionText = ThisItem.Question),{Delete: 1}); ForAll(TempQuestions,Patch(TempOptions, First(Filter(TempOptions, QID = TempQuestions.QID && TempQuestions.Delete = 1)),{Delete: 1})); Remove(TempQuestions,Filter(TempQuestions, Delete > 0)); Remove(TempOptions,Filter(TempOptions, Delete > 0)); Patch(QuestionPool,ThisItem,{Loaded: 0});

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(4)

Report
Copy link

Link copied!
@krickard

To find all of the records we need to update within TempOptions we can use this code

Filter(TempOptions, QID in Filter(TempQuestions, Delete =1).QID)

But to actually update them we can do this

UpdateIf( TempOptions, QID in Filter(TempQuestions, Delete =1).QID), {Delete: 1} )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
krickard 124 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks @mdevaney it works.

Was this reply helpful? Yes No