Answered

Always getting a blank line after patch in SharePoint List

(0) Share

Report

Posted on by jv123

226

I have reviewed several videos and documentation and tried all of the scenarios to get rid of the extra blank row in the SharePoint list. Initially there were two but the "Remove" function took care of that. I got the "if(!isblank)" idea from Shane Young but that didn't work for me.

Remove(ProjectCodeCollection,Last(ProjectCodeCollection));
ForAll(
ProjectCodeCollection,If(!IsBlank(Hours),
Patch(ReportingDetails, Defaults(ReportingDetails),
{Title: "ResourceHrs", ProjectCode: [@inputitem].Text,'Role/Task': RoleTask, Resource: Assigned , Hours: Hours, Comments: Comments, ReportingPeriod: Dropdown1.Selected.Title, PeriodBegin: Dropdown1.Selected.Begin, PeriodEnd: Dropdown1.Selected.End}
))
);

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

jv123 226 on at

Like
a
(0)

Report
Copy link

Link copied!

I have reviewed several videos and documentation and tried all of the scenarios to get rid of the extra blank row in the SharePoint list. Initially there were two but the "Remove" function took care of that. I got the "if(!isblank)" idea from Shane Young but that didn't work for me.

Remove(ProjectCodeCollection,Last(ProjectCodeCollection));
ForAll(
ProjectCodeCollection,If(!IsBlank(Hours),
Patch(ReportingDetails, Defaults(ReportingDetails),
{Title: "ResourceHrs", ProjectCode: [@inputitem].Text,'Role/Task': RoleTask, Resource: Assigned , Hours: Hours, Comments: Comments, ReportingPeriod: Dropdown1.Selected.Title, PeriodBegin: Dropdown1.Selected.Begin, PeriodEnd: Dropdown1.Selected.End}
))
);
Verified answer

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jv123 ,

You have two initial issues I can see - potential ambiguity with identical field names and also your ForAll Patch is backwards. ForAll is not designed to be a Loop, although it can work this way with considerable performance penalty as it does an individual Patch for each record. ForAll() creates a Table, which can be patched in one action provided its content is correct. For new records, this is simply a Table with field names and field types matching the list. None of it really explains the blank line, but try this

Patch( ReportingDetails, ForAll( Filter( ProjectCodeCollection, !IsBlank(Hours) ) As aPatch, { Title: "ResourceHrs", ProjectCode: [@inputitem].Text, 'Role/Task': aPatch.RoleTask, Resource: aPatch.Assigned , Hours: aPatch.Hours, Comments: aPatch.Comments, ReportingPeriod: Dropdown1.Selected.Title, PeriodBegin: Dropdown1.Selected.Begin, PeriodEnd: Dropdown1.Selected.End } ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps