Unanswered

Create flow to load a CDS entity data into another entity.

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I want to load one CDS entity data into another CDS entity through Flow or Data flow. The data will be truncated first from destination table then new data will be load. this process will be scheduled once in a day.

Could you please suggest me how can I do this?

Please also suggest if I can retrieve data from multiple entity based on common fields and load into another entity.

Regards,

Lalit Kadam

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

PavanKumar 479 on at

Like (0)

Report

Hi @Lalit Kadam,

Although am not clear why do you want to do that. Here are the steps on how you can achieve that.

1. Create a scheduled flow as mentioned - https://docs.microsoft.com/en-us/power-automate/run-scheduled-tasks
2. In that flow, read the data from your source entity (ideally recommendation is to read relevant records by adding filter) and create or update records in the target.
3. if you want to process data from more entities, then read all source entities data (with its relationship field) and create or update records in the target.

Regards,
Pavan Kumar Garlapati

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report

Hi @Anonymous ,

Do you want to load data from one Entity to another one?

Do you also want to load multiple Entity data into single one Entity?

Based on the needs that you mentioned, I think the Dataflow may be better solution for your scenario. There is an known limit with Dataflow currently -- we could not sync data from one Entity to another Entity through Dataflow directly.

As an fixed solution, you could export your source Entities into a CSV/Excel files. Then upload these exported CSV/Excel files into your OneDrive For Business folder. Then within your PowerApps, you could create a data flow to get Data from the stored Excel/CSV files hosted on your OneDriver through the "Excel" option as below:

Through the "Power Query" functionality in your data flow, you could get multiple data source (just repeat the "Get Data" operation). Then you could use "Merge queries" -> "Merge queries as new" option to combine multiple table (queries) into a single one table (query) based on common field (as you mentioned).

After that, you could load the combined query results into your destination Entity through Power Query Designer. You could set up a schedule for your data flow to run your data flow in a specific frequency.

More details about Power Query functionality, please check the following article:

https://docs.microsoft.com/en-us/power-query/power-query-quickstart-using-power-bi

More details about Data flow in PowerApps, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/self-service-data-prep-with-dataflows

According to the needs that you mentioned, I think Power Automate flow may not the better solution for you. E.G. If you want to retrieve data from multiple entity based on common fields and load into another entity, I afraid Power Automate flow could not achieve your needs.

If you just want to sync data from one Entity to another one, you could consider set up a Power Automate flow as below:

Please take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Pavan,
Thanks for your reply.
I am trying to create flow.
First I want to delete all data from "DueChemicalReview" entity(CDS entity). Once deletion complete want add data into "DueChemicalReview" from chemical entity(CDS entity). but I am facing issue while deleting and loading data.
Error :- "Invalid value:- ID provided for Item ID"
Please refer screenshot for same.
Do you have any proper video and steps where I can go through how can I achieve above functionality.

Regards,
Lalit Kadam

FlowIssue.png

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (0)

Report

Hi @Anonymous ,

Based on the error message that you mentioned, I think there is something wrong with the Dynamic content value provided for the "Item identifier" field in your "Delete a record" action of your flow.

When you want to delete a record using "Delete a record" action of CDS connector in your flow, please make sure you have chosen a proper Unique Identifier type column dynamic content for the "Item identifier" property in "Delete a record" action.

Please make sure you have chosen a proper Unique Identifier dynamic content (which should be marked Unique identifier as above) from Outputs of "List records" action for the Item identifier property in "Delete a record" action

Best regards,

Was this reply helpful? Yes No