Answered

Relational Field set to a Default Value in Editform not saving in Dataverse when Submitform is executed

(0) Share

Report

Posted on by espencere756

I have multiple relational tables. When I select a row from Table A on the primary screen, I display all related rows from Table B on a second screen, with the option to "Add a new Row". When I select the "Add New Row", it throws the form into Edit Mode, and I can add all the data. One field in this form is the Primary Key to Table A (to create the relationship). I have the editform set up to place the default value in the Key Filed Datacard, and I see it there on the form, but when I click on the submitform, everything entered into the form is saved EXCEPT for the field I set the default for. Thus, I get no relationship.

For the Default Value of the datacard for the ID field, I have the following...

If(EditForm_Installations.Mode = FormMode.New, VarRecord.Server_ID,ThisItem.DB_Install_Server_ID)

And, as I stated, I see the value there.

The Submit is just a simple

SubmitForm(EditForm_Installations)

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

espencere756 36 on at

Like
a
(0)

Report
Copy link

Link copied!

When I stated "And, as I stated, I see the value there.", I am seeing the value on the form, it is just not writing to the new row in Dataverse.

Was this reply helpful? Yes No
v-hanytian-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @espencere756 ,

May I ask what Formula you have used about varRecord?

We assume the formula of varRecord blow.

To fill the data in the Table B, we suggest use formula Lookup().
DefaultSelectedItems:
If(Form1.Mode = FormMode.New,LookUp('0711AS',Name in VarRecord.Server_ID,false))

Items:
Choices([@’Datasouse’].lookUpColumn)

Updata of DataCard:
DataCardValue3.Selected

Hope this will help you,

Best Regards,
Tina

Was this reply helpful? Yes No
espencere756 36 on at

Like
a
(0)

Report
Copy link

Link copied!

In the Previous Screen, I have the SET statement defined in the OnSelect property of the Gallery.

UpdateContext({ itemSelected: true, CurrentItem: ThisItem });Set(VarRecord,ThisItem);

In the Editform, In the Card for the ID, I have the following in the "Default" property of the card.

If(EditForm_Installations.Mode = FormMode.New, VarRecord.Server_ID,ThisItem.DB_Install_Server_ID)

I would normally "Hide" this field on the form, as I don't want anyone entering anything in it. It is to keep the new record relationship to the record on the first screen. However, for testing, I have made the field visible, and the value is showing when I am either viewing an existing record or if I am adding a new one. However, when I click save, that is the only field not getting added to the record in the table.

Was this reply helpful? Yes No
v-hanytian-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @espencere756 ,

As your offer, we change formula of the OnSelect in Galley.

We Suggest change formula of DefaultSelectedItems.
If(Form1.Mode = FormMode.New, LookUp(Choices([@'0711BS'].LookUpA),Name in VarRecord.Name))

Items of DataCardValue.
Choices([@'0711BS'].tina7_LookUpA)

Update of DataCard.

Hope this will help you.

Best Regards,
Tina

Was this reply helpful? Yes No
espencere756 36 on at

Like
a
(0)

Report
Copy link

Link copied!

I honestly do not understand this solution... the field I am trying to store is not a "Choice", it is a relationship filed. Also, I have had several days looking at each of the fields on the table I am trying to store, and I notice that there is no UPDATE property on that field. I am very confused why all the other fields in the table have UPDATE, but this one does not.
I will look further into the "Lookup" you have suggested, but I have never used it before, so I am not sure how to convert what you are suggesting to work with the objects I have on by screen. But, thank you for your response, I do appreciate it and value your knowledge on the matter.

Was this reply helpful? Yes No
v-hanytian-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @espencere756 ,

Actually, you can use this formula without any doubt.

The type of LookUpA we created is Look up in Dataverse.

Hope this will help you.

Best Regards,
Tina

Was this reply helpful? Yes No
Verified answer

espencere756 36 on at

Like
a
(0)

Report
Copy link

Link copied!

I have determined the problem. It has to do with how the table was created. These is an Access database that I have exported to Dataverse. I have no control over the data type created as the Export process does the creation. However, I believe the big issue has to do with the relationships defined in Access. I deleted all the tables in Dataverse, and I then removed ALL relationships in Access. I then performed the Export process again.
When I created the Screens this time, the field in question NOW has the UPDATE property and I am able to use the same Default formula I started with.
Thanks for all of your input on this. Unfortunately, I am very new to PowerApps, but need to recreate this Access Forms utility in Teams. I guess I need to sit down and better understand the Lookup functionality.

Was this reply helpful? Yes No