cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

collection not writing to sharepoint list

Good day,

I am trying to create a repeating table, i have not been able to have my collection written to the sharepoint list.

This is the issue i get after a running the app.

plutonicbean_0-1600158903277.png

This is my "onsuccess" formula:

 

ForAll(
Travelcollection,
Patch(
TravelDetails,
Defaults(TravelDetails),
{
TravelingFrom: frominput,
TravelingTo: toinput,
CostDetail: costinput,
MASTERID: Form3.LastSubmit.ID
}
)
)

 

-------------------------------------

Form3 is being filled in the list, but my collection does not. What am i doing wrong?

plutonicbean_1-1600159155099.png

 

Thank you advance!

5 REPLIES 5
Highlighted
Super User
Super User

Re: collection not writing to sharepoint list

For the travel Collection to work the First input must be the same name as the share pint Column name.  In your case one of the Columns (the first) may be named Title.  This is the default for first column irrespective of its name.

 

You should have an error though that shows that.  

 

It may also be you are not patching to the first Column and it is set to required.  This is also the default for that column

 

 

 

Highlighted
Helper I
Helper I

Re: collection not writing to sharepoint list

I will check that now, will update this post after. thank you for helping!

Highlighted
Helper I
Helper I

Re: collection not writing to sharepoint list

I have made some adjustments and i am now getting a differend issue notice, it is still not writing to the second list.

plutonicbean_0-1600166762950.png

 

plutonicbean_1-1600166811561.pngplutonicbean_2-1600166935720.png

 

I am working on this collection issue almost 3 weeks already, it's making me crazy hehehe...

 

 

Highlighted
Helper I
Helper I

Re: collection not writing to sharepoint list

I have just created the whole situation again from scratch i still get the problem with the ID:

 

plutonicbean_0-1600170698855.png

 

I would really appreciate the help.

 

Highlighted
Super User
Super User

Re: collection not writing to sharepoint list

LastFormSubmit shouid not be used in this syntax. Before your forall create a variable Set(LastrecordID,Form3.LastSubmit)  This creates a variable with every column in teh SP list with data from the last record

 

Then put the variable into your patch  using LastRecord.ID

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,007)