Hello all,
I have a question regarding the connections as datasource/database one can have in PowerApps. I have not worked yet with more than one at the same time, so am pretty much in the dark here. The question I have is: is it possible to have two Excel tables, from different files, as datasource at the same time? If so, then I have the following situation:
I have a form which works with the datasource one, "Consolidado_Piloto", which is the one the user access and can edit/modify some dates and add some comments. Each line of that file/table has also an unique ID. What I want to know is if it is possible that when an user edits and saves a form, asides from the form saving the changes in the datasource one, in the "table 2 / datasource 2" called "log", it would save the ID of the item that was saved plus the edited fields.
For example, form has:
- Project name (non editable [NE])
- Task name (NE)
- Start date planned (NE)
- End date planned (NE)
- Real start date (edited by user)/Input (I)
- Real end date (edited by user)/I
- Comment (edited by user)/I
- Finished (edited by user)/I
When user changes anything on it and saves it, the item, of course would be edited and saved, however, in the "table 2" (log), it would save the ID of the item that was edited (not sure if is needed to be in the form, but invisible), plus the edited fields. What is important is that each edit that is saved would be a new line in the table 2, not replacing a previous one.
Is this possible?
