cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Gorilla_8
Level 8

I AM HAVING ISSUES WITH REPATING TABLES LIKE INFOPATH

I am trying to build a refund app with two dynamic sharepoint lists, but they are not able to connect and save, I followed the steps of Shane Young, but I was not 100% successful, I need help. Here are some prints:

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: I AM HAVING ISSUES WITH REPATING TABLES LIKE INFOPATH

Hi @Gorilla_8 ,

Could you tell me the data type of these three fields: Título, ItemCost ,MasterID?

Please do not use patch to update a system field.

This kind of field will be generated data by system automatically, no need to update it.

You do not need to create new record with system field value, and you can not change system field value too.

System field is read-only.

Based on your description, I think maybe MasterID is a system field.

If so, I suggest you just update other fields.

Try this formula:

ForAll(ExpenseCollection; If(!IsBlank(LineItem);Patch(ExpenseDetails; Defaults(ExpenseDetails); {Título: LineItem; ItemCost: LineCost })))

Here's a doc about system field in sharepoint list for your reference:

https://sharepointmalarkey.wordpress.com/2008/08/21/sharepoint-internal-field-names/

 

 

Best regards,

 

 

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

10 REPLIES 10
cds
Level 8

Re: I AM HAVING ISSUES WITH REPATING TABLES LIKE INFOPATH

what does the error say?

Gorilla_8
Level 8

Re: I AM HAVING ISSUES WITH REPATING TABLES LIKE INFOPATH

ID: COLUMN IS GENERATED BY SERVER AND CANNOT BE SPECIFIED

cds
Level 8

Re: I AM HAVING ISSUES WITH REPATING TABLES LIKE INFOPATH

OK before your ForAll 
Set(VarMasterID, Form.LastSubmit.ID);
ForAll(.......MasterId: VarMasterID)

Gorilla_8
Level 8

Re: I AM HAVING ISSUES WITH REPATING TABLES LIKE INFOPATH

Set(VarMasterID; Form1.LastSubmit.ID);; ForAll(ExpenseCollection; If(!IsBlank(LineItem);Patch(ExpenseDetails; Defaults(ExpenseDetails); {Título: LineItem; ItemCost: LineCost; MasterID: Form1.LastSubmit.ID })))

 

This is my formula

cds
Level 8

Re: I AM HAVING ISSUES WITH REPATING TABLES LIKE INFOPATH

Set(VarMasterID; Form1.LastSubmit.ID);; ForAll(ExpenseCollection; If(!IsBlank(LineItem);Patch(ExpenseDetails; Defaults(ExpenseDetails); {Título: LineItem; ItemCost: LineCost; MasterID: VarMasterID })))

Gorilla_8
Level 8

Re: I AM HAVING ISSUES WITH REPATING TABLES LIKE INFOPATH

Same problem yet, i think its in sharepoint list

Community Support Team
Community Support Team

Re: I AM HAVING ISSUES WITH REPATING TABLES LIKE INFOPATH

Hi @Gorilla_8 ,

Could you tell me the data type of these three fields: Título, ItemCost ,MasterID?

Please do not use patch to update a system field.

This kind of field will be generated data by system automatically, no need to update it.

You do not need to create new record with system field value, and you can not change system field value too.

System field is read-only.

Based on your description, I think maybe MasterID is a system field.

If so, I suggest you just update other fields.

Try this formula:

ForAll(ExpenseCollection; If(!IsBlank(LineItem);Patch(ExpenseDetails; Defaults(ExpenseDetails); {Título: LineItem; ItemCost: LineCost })))

Here's a doc about system field in sharepoint list for your reference:

https://sharepointmalarkey.wordpress.com/2008/08/21/sharepoint-internal-field-names/

 

 

Best regards,

 

 

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Gorilla_8
Level 8

Re: I AM HAVING ISSUES WITH REPATING TABLES LIKE INFOPATH

Hi, the field: Tìtulo is the title by sharepoint list (Default), the field ItemCost its a currency field and the field MasterID is the ID of the item, but i need make a repeating table

Gorilla_8
Level 8

Re: I AM HAVING ISSUES WITH REPATING TABLES LIKE INFOPATH

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

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