Answered

Adding rows to table

(0) Share

Report

Posted on by Carl85

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.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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

Upload file to SharePoint and use data flow (with Power Query) to transform the data as required

Upload the records to Dataverse as the output of the Dataflow

Was this reply helpful? Yes No
Verified answer

ivan_apps 2,189 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Carl85 12 on at

Like (0)

Report
Copy link

Link copied!
Hello dpoggermann,

i need something like this.

When a dataflow refresh succeeds, start a Power BI dataset refresh.

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

Was this reply helpful? Yes No