Hey ;) I have a whole Dataset in an AZ Table Storage and i want to insert part of it (several collumns) into another AZ Table Storage using AZ Logic Apps. Could anyone help me? I'm totally new with AZ Logic Apps. Thank you!

@Raphael Schnizler Thanks for reaching out. I will suggest reviewing this document to get familiar with different logic app offerings. Azure logic app offers different connectors and you can find the list in this document . The individual connectors document can provide you with more details on different triggers/actions available for that connector. For your requirement, you can create any trigger as per your need and leverage the Azure tables connector to perform different operations on the azure storage table. Workflow: Any Trigger as per your requirement --> Get Entities (get rows from your existing table) --> Loop through the result set of Get Entities --> Insert Enity (insert row in new table) Not specific to the storage table but you can refer to this document which talks about the azure blob connector which can help you to understand configuration parameters while connecting to the storage account. Feel free to get back to me if you need any assistance.

AZ Logic App: Saving Data from one AZ Table Storage to another (not all collumns from AZ Table Storage 1 in AZ Table Storage 2)

Accepted answer

MayankBargali-MSFT 70,731 Reputation points

2022-03-30T11:55:02.717+00:00

@Raphael Schnizler Thanks for reaching out. I will suggest reviewing this document to get familiar with different logic app offerings.
Azure logic app offers different connectors and you can find the list in this document. The individual connectors document can provide you with more details on different triggers/actions available for that connector.

For your requirement, you can create any trigger as per your need and leverage the Azure tables connector to perform different operations on the azure storage table.

Workflow:
Any Trigger as per your requirement --> Get Entities (get rows from your existing table) --> Loop through the result set of Get Entities --> Insert Enity (insert row in new table)

Not specific to the storage table but you can refer to this document which talks about the azure blob connector which can help you to understand configuration parameters while connecting to the storage account.

Feel free to get back to me if you need any assistance.
Please sign in to rate this answer.
Raphael Schnizler 66 Reputation points

2022-03-31T14:42:15.647+00:00

Thank you for your response...it helped me a lot.

I have another question, which goes a bit further:

In my usecase, i only want to copy new rows from table storage 1 to table storage 2. Sadly there is no trigger this case for the table storage (as it is ther for the blob).
My idea was, to add a column with a flag for new in table storage 1. in the loop, after the needed columns of the row where written to table storage 2, the row has to be changed/overwritten to set the flag to not new in the added column

You think this is possible?

thanks for the help!

MayankBargali-MSFT 70,731 Reputation points

2022-04-04T06:44:41.737+00:00

@Raphael Schnizler Thanks for your response. Yes unfortunately there is no trigger for table storage that can help you with your use case.
There are multiple ways to handle this in your custom solution. One way as you have suggested is to update the column and get only those rows based on the flag value. I will suggest you to review the Design query document for better performance as in a scenario when there are huge rows so the performance may be impacted if you are not leveraging the partition/row key in your query.

The alternative if you want to update your application code, i.e. updating storage 1 table. Assuming that there can be no changes from other applications to that storage 1 table data and it is possible to update the application code. In that case, you can update the application code and send the same data to the storage queue/service bus where you can trigger your workflow as we have supported trigger for azure queue and service bus.

Feel free to get back to me if you have any queries or concerns. Feel free to 'Accept as answer' so that it can help others in the community looking for help on similar topics.

Raphael Schnizler 66 Reputation points

2022-04-04T09:25:15.64+00:00

Thank you very much for your response!

I'll test it soon and will give you feedback / mark it as solution ;)
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

AZ Logic App: Saving Data from one AZ Table Storage to another (not all collumns from AZ Table Storage 1 in AZ Table Storage 2)

0 additional answers

Your answer