Announcements
No record found.
I want run my flow only once and i.e. on create of work order. but its not working giving below error:
and after trying multiple suggestions given in community i updated trigger to 'create or update' then the flow worked fine without error , but it ran multiple times. how to avoid that.
flow looks like this:
Hi Sayali,
Maybe you can add one Column filter in the trigger, the flow will only be triggered when creating work order or updating the field, which means that the flow can’t be triggered when other fields not update.
Based on your previous cases, worker order and Asset is N:1 relationship, there is an Asset lookup field in the worker order form, you can set the lookup field as column filter.
Then filling the logic name of the lookup field in the ‘Column Filter’.
For example, Account and contact is 1:N relationship, one account lookup field(Account) in the contact form, the logic name of it is ‘parentcustomerid’.
Note: if you want to the flow can be triggered when creating new work order, the asset lookup field in work order form must be filled before clicking save button.
Regards,
Leah Ju
Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
Why do you have the Delay step?
Show what you have inside the List Records step - the error is basically saying I am comparing a String and a Guid and can't because they are different data types
HI Leah, Yeah that worked. But still flow executed twice and duplicates of work order checklist is created. is there any way where i can check if work order checklist record with combination already exists?
when i change the trigger this error goes away and it works fine. i tried multiple possible ways to avoid this issue by adding GUID or by using its schema name(plural), issue is not in filter. also i have removed delay step
It’s so strange, the flow is triggered twice and work order checklist is duplicated.
Maybe you can create new field for work order but not adding it to the form, and fill the logic name of the new field to ‘Column Filter’, then run the flow to check how many times it has run.
If it is still not work, can you provide more screenshots about work order form with asset lookup field, their check list records and details of the flow, which can make me test it with same steps and conditions.
Note:Screenshots should not contain sensitive private information.
Hi,
Flow:
Error:
Work order form- Asset field details:
Work order form:
New field suggested by you:
now its not even working for create or update trigger :( please check and let me know what i am doing wrong
The only reason for the error is that the asset lookup field value is null when the work order created, you need ensure Asset lookup field in work order is filled when creating work order.
From your screenshot, the asset lookup field in work order form is custom field you created, right?
And you also mentioned that “work order is getting created from agreement and asset field getting mapped on create itself.”
So the ‘Asset’ lookup field is filled automatically or not when generating work order from agreement?
Test:
Asset lookup field is filled.
Asset lookup field is null.
Or you can create a new simple flow(only two steps) by adding 'Compose' action to check the asset field is null or not when generating new work order.
Result:
Thanks leah, its working now without error, Issue was the same you mentioned- asset value is null on create of work order.
its just running twice, i checked the audit history also. asset is updated only once. still the flow is running twice.
Hi Leah,
the issue is resolved as i have changed filter column to field 'Column filter' . i am updating column filter on create of work order when asset contains data. so flow runs only when 'column filter' updates and when asset contains data.
Thank you so much for all the support :)
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Syed Aqib Raza 42
11manish 21 Super User 2026 Season 2
Travis South 19
