Hi,
I have created a form that reads a csv file and insert data of csv file in a table but what i want if data in csv file is same as data of master table then only it should inserted in table else throw an error message of wrong data.
Hi,
I have created a form that reads a csv file and insert data of csv file in a table but what i want if data in csv file is same as data of master table then only it should inserted in table else throw an error message of wrong data.
Hi,
Have you written c# code to insert record in dataverse table, if yes then you can use fetchxml to verify the data in Master data entity before inserting the record as shown below-
Permit Type is an example entity which you can replace with your entity name and add the condition. Now you can execute this fetchxml in your to check if any record is returned, if record count is >0 meaning record is present in master data, you can insert the data in table.
Please mark my answer verified if this is helpful!
Regards,
Bipin Kumar
Follow my Blog: xrmdynamicscrm.wordpress.com/
Hi Megha,
Can you tell me what app you are using in dynamics 365?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156