Power automate flow works fine when trigger is set to ' on create or update' but doesn't work when set to ' on create' only

(0) Share

Report

Posted on by Sayali

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:

All responses (9)

Answers (2)

Sayali 20 on at

Like (0)

Report

RE: Power automate flow works fine when trigger is set to ' on create or update' but doesn't work when set to ' on create' only

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 :)
Sayali 20 on at

Like (0)

Report

RE: Power automate flow works fine when trigger is set to ' on create or update' but doesn't work when set to ' on create' only

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.
Verified answer

Community Member on at

Like (0)

Report

RE: Power automate flow works fine when trigger is set to ' on create or update' but doesn't work when set to ' on create' only

Hi Sayali,

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:

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
Sayali 20 on at

Like (0)

Report

RE: Power automate flow works fine when trigger is set to ' on create or update' but doesn't work when set to ' on create' only

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
Community Member on at

Like (0)

Report

RE: Power automate flow works fine when trigger is set to ' on create or update' but doesn't work when set to ' on create' only

Hi Sayali,

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.

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
Sayali 20 on at

Like (0)

Report

RE: Power automate flow works fine when trigger is set to ' on create or update' but doesn't work when set to ' on create' only

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
Sayali 20 on at

Like (0)

Report

RE: Power automate flow works fine when trigger is set to ' on create or update' but doesn't work when set to ' on create' only

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?
Fubar 2,756 on at

Like (0)

Report

RE: Power automate flow works fine when trigger is set to ' on create or update' but doesn't work when set to ' on create' only

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
Verified answer

Community Member on at

Like (0)

Report

RE: Power automate flow works fine when trigger is set to ' on create or update' but doesn't work when set to ' on create' only

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.