How to filter empty or blank items from gallery before patching

(0) Share

Report

Posted on by davidvo68

114

Hi all,

My code below is to patch to my SharePoint List from a collection, colSubmittedQuestion which being populated by a gallery.allitems, and it is working perfectly if I don't have the RemoveIf statement in it.

Without removing the blank or empty records, the patch function patches ALL items.

My TriagedScore column is a type choice and it has 1,2,3 as choices inside a gallery and all items are being collected into a collection called colSubmittedQuestion. Please see the image below.

My code:

ForAll(

RemoveIf(colSubmittedQuestion, IsBlank(TriagedScore) || IsEmpty(TriagedScore)), // this is the statement I need help with

RenameColumns(colSubmittedQuestion,"ID", "SID"),
Patch('Fenced Triaged Review Checklist',
LookUp('Fenced Triaged Review Checklist',ID = SID),
{ProgramName:ProgramName, ProgramID:Value(ProgramID),
ARIWGInitialDate:ARIWGInitialDate, ARIWGCompletionDate:ARIWGCompletionDate,
PriARIWGPOC:PriARIWGPOC, AltARIWGPOC:AltARIWGPOC, Member:Member,
SIMAlignment:LookUp(Choices('Fenced Triaged Review Checklist'.SIMAlignment),Value=SIMAlignment.Text), SectionNumber:Value(SectionNumber.Text),
TriagedScore:LookUp(Choices('Fenced Triaged Review Checklist'.TriagedScore),Value=TriagedScore),
QuestionNumber:Value(QuestionNumber), Question:Quesion, ARIWGComment:ARIWGComment, BusinessOwnerComment: BusinessOwnerComment,
ResultCommunicate2POC:ResultCommunicate2POC, Resultof2Submission:Resultof2Submission,
SecondSubmissionDate:SecondSubmissionDate, OverallAssessComment:OverallAssessComment,CMB:CMB

}
));

Thank you in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Al_10 1,691 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@davidvo68

you can try this

ForAll( RemoveIf(RenameColumns(colSubmittedQuestion,"ID", "SID"), IsBlank(TriagedScore) || IsEmpty(TriagedScore)), Patch('Fenced Triaged Review Checklist', LookUp('Fenced Triaged Review Checklist', ID = SID), { ProgramName: ProgramName, ProgramID: Value(ProgramID), ARIWGInitialDate: ARIWGInitialDate, ARIWGCompletionDate: ARIWGCompletionDate, PriARIWGPOC: PriARIWGPOC, AltARIWGPOC: AltARIWGPOC, Member: Member, SIMAlignment: LookUp(Choices('Fenced Triaged Review Checklist'.SIMAlignment),Value=SIMAlignment.Text), SectionNumber: Value(SectionNumber.Text), TriagedScore: LookUp(Choices('Fenced Triaged Review Checklist'.TriagedScore),Value=TriagedScore), QuestionNumber: Value(QuestionNumber), Question: Quesion, ARIWGComment: ARIWGComment, BusinessOwnerComment: BusinessOwnerComment, ResultCommunicate2POC: ResultCommunicate2POC, Resultof2Submission: Resultof2Submission, SecondSubmissionDate: SecondSubmissionDate, OverallAssessComment: OverallAssessComment, CMB: CMB } ) );

Was this reply helpful? Yes No
davidvo68 114 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you Alex. I tried your modified code and it did take care of the error. However, it still went thru and updated all of the gallery items including the blank/empty ones.
Any other suggestion? I was thinking of instead doing the remove blank/empty items, just update the ones which has value of 1,2,3 in the column but not sure how to modify the code.

Was this reply helpful? Yes No
davidvo68 114 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Alex, sorry that I spoke too soon. It did work with your modified code. Thank you so much.
Another question though related to this code. How would I modify this code just to update the items which being changed or modified?

Was this reply helpful? Yes No
Al_10 1,691 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@davidvo68

there is no an easy way to do that.

Was this reply helpful? Yes No