Update PowerPlatform Table if Table from semantic model has new data (connected to D365)

[Caifanes9012]

Hi I  have a question, I am not sure if this is possible.

I have a semantic model table in PowerBi that is taking information directly from D365 and refresh itself (the main column I care about is the ID) . I created a table in PowerPlaform with the ID column and other ones that will be written through a form through PowerApps. I was wondering if it is possible to get the ID column data from the Semantic model table and parse it into the PowerPlatform table? is that possible? Even if there are new Ids will these be added or it would need to be through automation?

Thank you.

[Anonymous · Accepted solution]

Hi  @Caifanes9012 ,

You might want to consider using Power Automate to create a flow that triggers whenever a new ID is added to the D365 table, and then adds that ID to the PowerPlatform table. This would ensure that your PowerPlatform table is always up-to-date with the latest IDs from the D365 table.

Common ways to use a form in a flow - Power Automate | Microsoft Learn

Solved: Autogenerating a unique ID number - Power Platform Community (microsoft.com)

Please be free to ask me if I misunderstood your needs.

Best regards.
Community Support Team_Caitlyn