Notifications
Announcements
Dear All,
I try to create my workflow by Power Automate to create a records in share point when a new record are created in Dynamic D365.
But When I search to see a video I feel that some feature are difference can someone guide me how to do it.
Thanakorn Kanjiropas The above suggestion won't work as we can't select a field on alert for 'When a record is Deleted', it be all fields and you won't find exact Customer which is deleted. This has been discussed before, please check this thread. It would be possible via customization but by creating a custom business event.
community.dynamics.com/.../alerts-in-d365fo-that-is-working-quite-well-except-when-then-action-is-delete
I think issue might be that your power automate will not know which record is deleted. You have got FieldId zero because All Fields are set on alert for delete. I'm not sure but can you try to set Customer Id instead of all fields on alert for when record is deleted. Maybe you will get customer account in business event and then power automate.
Then you can delete correct record from your SharePoint list. Give it a try and let us know if it works.
Now I can get an idea to do an update process. But for delete when I check a schema file when I download from this step.
I got a messag like this if I want to get a Customer ID, Can you guide me how to do??
How about using Get Items from Sharepoint List and filter on your customer account. If you get the record, fetch Id in variable and use in Update Item step (Haven't tested but you can try it)
www.youtube.com/watch
learn.microsoft.com/.../working-with-get-items-and-get-files
Now I got some limitation when I want to edit or deleted.
When I use power automate to update in my share point record
this is a sharepoint record:
this is a D365 records:
when I do a power automate step they will required id but it's not my primary key how should I do? can you advise?
That's great, Using change based alerts will work but if you have multiple alerts in future, your power automate will be called every time, so best way is to create Business event specific to your requirement.
Please mark answer verified if any helped you.
Oh sorry, It was sound delay for power Automate. Now it's working thank you.
Yes
I go to System administrator>Periodic Task>Alert>Change Based Alert and see it.
You need to activate the business event. Have you activated it?
HI!
I Try to do in this step
1. I prepare my Sharepoint list with 3 Field[CustomerID,CompanyName,Remarks]
2. I Access to D365 for check my batch Job
3. I access to a page records and create a custom alert (This case I want to create sharepoint record when new record are create in D365) => Record Id:000000076
4. I go to system administrator>Setup>Business Events >business Event Catalog then filter category "Alert" on business events AlertEvent then download a schema.(to use in Power Automate Step)
5. I start with "When a Business Event Occurs"
6.then I choose a step Parse JSON and put a schema that I download on previous step
7. After that I choose Condition and Put rule ID to match with my RUle ID
8. if Yes I get a record and put it in share point
9 Save and no error after that I try to create a record in a new customer but when I got a new record in D365, About my Power Automate are not running.
what's wrong is it can some one guide me?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 843 Super User 2025 Season 2
André Arnaud de Cal... 405 Super User 2025 Season 2
Martin Dráb 322 Most Valuable Professional
