nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is it possible to edit data for a related table from a form filled out in PowerApps?

RPGIS

Hi,

I was wondering if it was possible to edit attributes for a related table that is created from a feature using the link to create the related table that will then open a power apps form. The user then fills out the form, which will also fill out the related tables attributes. I have yet to test this but I was thinking that since both can connect to a SQL database, the SQL database could then act as the main database for both.

Any help on this would be greatly appreciated.

Robert

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

RPGIS

Hello Jon,

I figured that may be the case. The reason I am looking into this as a solution is that with a standalone table is that I can update the attributes using PowerApps and, as long as there is a unique ID created, I believe it is theoretically possible to update the table using PowerApps and then using a python script to update a feature class or tie the table in as a related record.

The other reason is, compared to Survey123, rather than having to rely on a separate service to have to connect to, I can use PowerApps to keep the table fields and structure as is and have it update using the PowerApps form. The flexibility and control that comes with PowerApps is the other reason I have been looking into this.

JEmch

Hello Robert,

"That is an interesting question... You are able to connect to the Geodatabase as you would to any SQL server db. Updates and edits to the main table will work, but there will likely be problems updating the related items. ArcGIS clients are aware of the relationships because they know to query the geodatabase repository for relationship classes, etc. It's built into the client code. The PowerApps app isn't aware that the geodatabase repository exists so it will only update the main table.

RPGIS

Hey Jon,

I was simply talking about being able to edit data in either a related table or the attributes of a feature class through a PowerApps form. I noticed in PowerApps that there is the ability to connect to a data source through a SQL server and since most GIS Enterprise Databases are also on SQL servers, I thought there might be a way to connect to the data in a SQL server that updates the attribute data of a feature class when the form is updated. I was asking if anyone knew of a similar set up or something akin to it.

JEmch

Hey There Robert,

Are you talking about Microsoft's Power Apps application as it relates to PowerBI or the ArcGIS Maps for PowerBI Visual?

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.