Answered

Collection Path Not Saving to SharePoint

(0) Share

Report

Posted on by kmw1130

995

I am trying to Patch my Collection to my SharePoint List. The collection looks good and has the saved values, but when I Patch that collection to SharePoint, nothing happens. I'm using a dropdown within my Powerapp for a status field, and saving that to a single line text field in SharePoint. Could that cause the issue?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@kmw1130
Please post the Patch() function that you are using to save your collection to the SharePoint list.

Was this reply helpful? Yes No
kmw1130 995 on at

Like (0)

Report
Copy link

Link copied!

This is on the OnSuccess of my Main Form:
Line... are the names I used to create my Collection.

ForAll(TrackingCollection, If(!IsBlank(LineType),Patch('Program Tracking', Defaults('Program Tracking'),
{
Title: LineType,
'Contract Name': LineProgramName,
'Assigned To': LineAssignedTo,
'Date Identified': DateValue(LineDateIdentified),
'Date Closed': DateValue(LineDateClosed),
'Description': LineDescription,
'Tracking Resolution': Value(LineResolution),
Likelihood: Value(LineLikelihood),
Impact: Value(LineImpact),
BU: LineBU,
ProgramID: FormIssues.LastSubmit.ID})));
Navigate(TrackingOverviewScreen,ScreenTransition.Fade)

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@kmw1130

Is your collection a single record and are you trying to save the record to a different list?

Was this reply helpful? Yes No
kmw1130 995 on at

Like (0)

Report
Copy link

Link copied!

No, it is multiple records possibly (currently there are 2 items to be patched to my SP List). I'm using a gallery as my repeating table, which saves to the collection, but then does not save to SP.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi@kmw1130,

Based on the issue that you mentioned, do you want to save the collection to your SP list?

Could you please tell me that if this collection is your repeating table in the Gallery?

Actually, you could directly populate a Gallery with the collection, and then patch all the gallery items to SP list.

Please try the following formula:

ForAll( YouGalleryName.AllItems, If(!IsBlank(LineType),Patch('Program Tracking', Defaults('Program Tracking'), {Title: LineTypeLabel.Text, 'Contract Name': LineProgramNameLabel.Text, 'Assigned To': LineAssignedToLabel.Text, 'Date Identified': DateValue(LineDateIdentifiedLabel.Text), 'Date Closed': DateValue(LineDateClosedLabel.Text), 'Description': LineDescriptionLabel.Text, 'Tracking Resolution': Value(LineResolutionLabel.Text), Likelihood: Value(LineLikelihoodLabel.Text), Impact: Value(LineImpacLabel.Textt), BU: LineBULabel.Text, ProgramID: FormIssues.LastSubmit.ID}))); Navigate(TrackingOverviewScreen,ScreenTransition.Fade)

Hope it could help.

Regards,

Qi

Was this reply helpful? Yes No
kmw1130 995 on at

Like (0)

Report
Copy link

Link copied!

@v-qiaqi-msft Yes, this is a repeating gallery. I am trying your suggestion and will follow-up with the results.

Was this reply helpful? Yes No