Answered

I AM HAVING ISSUES WITH REPATING TABLES LIKE INFOPATH

(0) Share

Report

Posted on by Gorilla_8

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:

Here the video>

https://www.youtube.com/watch?v=xgznk4XlPCo

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

cds 1,001 on at

Like
a
(0)

Report
Copy link

Link copied!

what does the error say?

Was this reply helpful? Yes No
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

ID: COLUMN IS GENERATED BY SERVER AND CANNOT BE SPECIFIED

Was this reply helpful? Yes No
cds 1,001 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
cds 1,001 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

Same problem yet, i think its in sharepoint list

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

Here the videos i follow the step:

PArt 1: https://www.youtube.com/watch?v=xgznk4XlPCo

Part 2: https://www.youtube.com/watch?v=DylxsXIUyDc

Part 3: https://www.youtube.com/watch?v=HUX_0AA4-Hs

Was this reply helpful? Yes No
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

This formula works, but i have another problem, there's a second gallery to show the item details, and ara not showing.

The print: https: // prnt.sc / pt95n9

Was this reply helpful? Yes No