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
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?
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.