How to do Incremental Load(or load newly created record) from Azure AD to CDS table on daily run using Flow

[Durga]

Hi, 

I have a flow, which gets data from Azure AD to CDS entity/table 

 - Initial load is fine: loading/inserting all the data from Azure AD to CDS entity/table 

 - In next runs: it should load or insert latest data from Azure AD to CDS table if records does not exist

I have 2500+ Azure AD group members in SG/DLs:

 - I should not truncate main table because other column updates happened from PowerApps

Thanks

Durga

[Spamrancher]

Did you mean to put this in the PowerApps forum? Seems like it would be a PowerAutomate forum question. That being said, maybe you filter your AD records based on CreatedOn > your-last-Flow-run-time and then check those to see if a Dataverse record already exists?

[Durga]

Hi @Spamrancher 

Thanks for your reply. CreatedOn is not getting from Azure AD.

I got the solution based on another field using to populate only group wise data, now its working.