Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[JIKEN DUBAL]

Hi,

I have created one canvas app which connect to on-premises SQL Server DB. This app is working fine with first table connection for Gallery, Edit form.

My scenario is as below

1. Master table with 10 records
2. Load data at Gallery at Scrollable screen Screen1 by connecting master table at SQL Server 
3. Selected record for edit in second screen Screen2 with Edit form and it works fine.
4. This form is also work fine for add new record.
5. Connect another details table from Data Sources
6. Details table with 50 records against all 10 records of master table 
7. Load data at Gallery at Scrollable Screen Screen3 for selected record in master table gallery and it also works fine.
8. Creating another Edit form at New Blank Screen Screen4 by selecting details table as Data Source and Add Fields
9. Above form will show data based on selected record in Details Gallery, but it is not editable.
10. Even try to add new record, no textbox is showing.

Please help or suggestions in it ASAP.

Thanks in advance.

Regards,
Jiken

——————————
JIKEN
——————————

[Koen Mathijs]

Hi,

can you maybe share your code for below properties of your edit form in Screen4:
* datasource
* items
* Defaultmode

You added an Edit Form and not a Display Form I guess?

——————————
Koen Mathijs
——————————
——————————————-

[JIKEN DUBAL]

Hi Koen,

Below properties of edit form in Screen4:
* datasource: details table connected at on-premise SQL Server DB.
* item: Gallery3.Selected
* Defaultmode: Edit

Yes I have added Edit form and not display form.

I have tried copied 1st form and change datasource from master table to details table.
Removed old fields and selected new fields its properties are changed. – 🙁

——————————
JIKEN
——————————
——————————————-

[Koen Mathijs]

Hi Jiken,

not sure what you mean by “its properties are changed” but by the look of your smiley I guess it didn’t work out.

With a default 3-screen-app the property of the editform defaultmode = new but I’m not sure that this will resolve your problem. I have the feeling that it is rather related to the relationship between your master and details table. Can you maybe give some example data of your master and details table?

——————————
Koen Mathijs
——————————
——————————————-

[JIKEN DUBAL]

Hi

We can copy existing Edit Form which is in working condition and Paste it in another screen for edit details. So, change data source from master table to details table and add fields which control type is view text / view reach text and no edit text option and Data Card has only two controls DataCardValue and DataCardKey.

Here is the table data.

Master Table (MasterID is Primary Key and Clustered Index)

MasterID	Name
1	Product A
2	Product B
3	Product C
4	Product D
5	Product E

Details Table (DetailID is Primary Key and Clustered Index, MasterID is Foreign Key and Nonclustered Index) 

DetailID	MasterID	Color	Ideal For	Size
1	1	Black	Boy	3-4 years
2	2	White	Girl	3-4 years
3	3	Red	Man	3-4 years
4	1	Yellow	Boy	8-9 years
5	2	Blue	Girl	8-9 years
6	3	Green	Man	8-9 years
7	4	Cream	Woman	8-9 years
8	5	Brown	Boy Kid	10-11 years
9	1	Grey	Boy	11-12 years
10	2	Orange	Girl	11-12 years

I hope that this will help you to understand my scenario and problem.
Please give me solution.

Thanks in advance.
?

——————————
JIKEN
——————————
——————————————-

[Koen Mathijs]

Hi Jiken,

I understand your problem but I can’t replicate it in my environment. I have the same setup, SQL server with master and details table and my Edit form is also  connected to the details table in a separate screen. If I add a field to the form I have all sorts of control types and it should be set to “edit text” to be editable. I Don’t know exactly why you don’t have that choice.

I can only suggest to not start from a copy and start your screen from scratch. Insert new screen – insert new edit form – connect it to your details table and add the fields that you want. You should get all the control types that you need. Otherwise I guess there is something wrong with your SQL table properties. I’m no SQL expert and I see that only the primary key is set in my environment (which is the only prerequisite). Maybe try to remove the foreign key setting?

Also have a look at this thread, it explains exactly what is going on in your case: https://powerusers.microsoft.com/t5/Building-Power-Apps/Edit-form-is-not-editable/td-p/727180. Creating the form from scratch ultimately did the trick

——————————
Koen Mathijs
——————————
——————————————-

[JIKEN DUBAL]

Hi Guys,

It is resolved as below

1. Removed existing clustered index and non clustered index on details table.
2. Again created clustered index and non clustered index on details table.
3. Refresh table connection at Canvas App.
4. Remove existing details edit form.
5. Create new edit form and add required fields.
6. And ?? – Fields are editable. – ??

Thank you so much for your reply.

——————————
JIKEN
——————————
——————————————-

[Koen Mathijs]

Hi Jiken,

glad to hear you got it resolved.

Also be aware that if you change anything on your SQL Table scheme after you have added the connection to a canvas app you need to at least refresh it, in some cases even remove it and add it again before those changes are reflected.

Copying forms is not always the best way to go 😉

——————————
Koen Mathijs
——————————
——————————————-