cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

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
Highlighted
Community Support
Community Support

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
Highlighted
Impactful Individual
Impactful Individual

Re: I AM HAVING ISSUES WITH REPATING TABLES LIKE INFOPATH

what does the error say?

Highlighted
Post Prodigy
Post Prodigy

Re: I AM HAVING ISSUES WITH REPATING TABLES LIKE INFOPATH

ID: COLUMN IS GENERATED BY SERVER AND CANNOT BE SPECIFIED

Highlighted
Impactful Individual
Impactful Individual

Re: I AM HAVING ISSUES WITH REPATING TABLES LIKE INFOPATH

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

Highlighted
Post Prodigy
Post Prodigy

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

Highlighted
Impactful Individual
Impactful Individual

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 })))

Highlighted
Post Prodigy
Post Prodigy

Re: I AM HAVING ISSUES WITH REPATING TABLES LIKE INFOPATH

Same problem yet, i think its in sharepoint list

Highlighted
Community Support
Community Support

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

Highlighted
Post Prodigy
Post Prodigy

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

Highlighted
Post Prodigy
Post Prodigy

Re: I AM HAVING ISSUES WITH REPATING TABLES LIKE INFOPATH

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

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

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