You’re offline. This is a read only version of the page.
12
Hello everyone,
I have the following challenge. I have a .txt file that I upload to Sharepoint from my PC. Whenever this file is updated in Sharepoint, the contents of the new file should be added to an existing table in Dataverse. How should I proceed here? I can get a new row with predefined content to be added to the existing dataverse table. But nothing more. The background is that I need to create a continuous table of production capacities. I want to be able to see how the capacity for day X has changed on different observation days.
Before the data from the .txt file can be added to the Dataverse table, various transformation steps have to be carried out. (E.g. removing the first four lines, upgrading the first line as header, truncating spaces). I have already read a lot in the forum but have not made any progress. I am at my wit's end and would be grateful for any ideas or help.
Hello dpoggermann,
i need something like this.
I'm still not quite sure how to get the whole data refresh updated.
https://learn.microsoft.com/en-us/power-query/dataflows/dataflow-power-automate-connector-templates
Sounds like you have a CSV file or XLSX file instead of a txt file the way you describe the transformations.
Also sounds like exactly what Power Query would do, so Power App Dataflows would be your best bet to transform and insert rows into and existing table.
Alternatively you could use Power Automate and the excel connector to grab the defined table in the file and iterate using predefined table metadata. However transformations using PA aren’t as good as Power Query capabilities so it’s a bit more work on that side.
Hi @Carl85
Have you looked at data flows here to accomplish your needed process? https://learn.microsoft.com/en-us/power-query/dataflows/overview-dataflows-across-power-platform-dynamics-365
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
19
#3
Michael E. Gernaey
15
Super User 2025 Season 1
Share
Report
All responses (
Answers (
