I'm facing difficulties with modifying data in my Power Apps applications. Initially, I fetch data from a database to retrieve resources, and then I store the selected data in a collection, which also contains other cached data. The external collections refer to SharePoint lists that are not the ones I'm directly working on.
The issue arises when attempting to modify data in SharePoint. The default values do not load correctly because they reference data stored in a variable that is not saved. Although I've used the data from the variable, it has been concatenated and no longer has the same format, making it impossible to retrieve. Default values are crucial for data modification in Power Apps, as they load the desired data when editing an existing row.
I'm wondering if there's a way to set default values using data from the external collection or if there's another approach to solving this data modification issue in Power Apps.