cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Durga
Microsoft
Microsoft

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

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

 

2 REPLIES 2
Spamrancher
Resolver I
Resolver I

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
Microsoft
Microsoft

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.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,741)