News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Data Entity field cann...

Finance | Project Operations, Human Resources, ...

Unanswered

Data Entity field cannot be edited in sandbox and production environments

(1) Share

Report

Report

Posted on by EK-26061005-0

143

I have created a data entity from a custom table and outer joined CustVendExternalItem table as child data source to add ExternalItemId field, along with custom table fields. According to our power apps developer the ExternalItemId field is editable from PowerAutomate but not in sandbox or production; even when allow edit is set to yes and is read only property is set to No in entity root and field. What should i do to make this field editable in every environment?

All responses Img

All responses (2)

Answers Img

Answers (0)

EK-26061005-0 143 on at

Like (0)

Report

Data Entity field cannot be edited in sandbox and production environments

I apologize for the confusion. The attempt to change the field is made from Power Automate, not PowerBI. Also the allow-edit property of the field in data entity was set from auto to yes and then deployed to sandbox but the field is still immutable.
Martin Dráb 230,371 Most Valuable Professional on at

Like (0)

Report

Data Entity field cannot be edited in sandbox and production environments

I guess you want to edit the data from a Power App, not Power BI, right?

How are you accessing the entity from your app? Are you using the F&O connector, a Dataverse virtual entity or what?

You mentioned it doesn't work in sandbox and production, but it works in development environments. Have you deployed your changes to the other environments?

What exactly do you mean by saying that it's not editable? For example, are you getting an error when trying to update a value of that field? Does the record exist in your test scenarios in dev and sandbox environments? It's outer-joined, therefore it may but doesn't have to exist.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2

Martin Dráb 230,371 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans