How to trigger an Opportunity by changing the estimate close date

(0) Share

Report

Posted on by Community Member

I hope this makes sense to someone out there. Thank you in advance, and I hope I can find a mentor here. My request will come in the form of too many statements and unclear questions.

I am trying to update the planning data on the opportunity products called (X). I want the opportunity products (X) where opportunity equals (X). Looking at all the instructions I was given, I am trying to update the opportunity product table but only the opportunity product related to opportunity (X).

Update only the related line item table within the opportunity (X) I trigger.

So I trigger an opportunity (X) by changing the estimated close date. Now I want to update the planning on the child line item of Opportunity (X) ( Not on every line item on every opportunity), just the one related to the one that triggers it.

So we need to be able to filter in this update row.

When creating a flow in Power automate, I couldn't figure out what the Row ID is?

I need to figure out how to retrieve the Row ID from the parent opportunity to show how or how to get the Row IDs.

Please take a look at my screenshots.

If you have a site or a blog on step-by-step instructions, that will be greatly appreciated.

Thanks

All responses (5)

Answers (0)

Community Member on at

Like (0)

Report

RE: How to trigger an Opportunity by changing the estimate close date

New problems arise and I can't figure out how to fix it.

The Planning dates don't the line items get updated as the estimated date gets updated too. Now, I want to add days to the planning dates of the child record as the estimated date gets modified.

I have used the add days format and I keep getting the error message. I even added the variable and that didn't help.

Error message: Unable to process template language expressions in action 'Update_a_record_(deprecated)' inputs at line '1' and column '22072': 'In function 'addDays', the value provided for date time string '25ub(inP(e25Pi27aPeclo25e11aPe,1lir_previou25clo25e11aPe))' was not valid. The datetime string must match ISO 8601 format.'.

Date format: formatDateTime(addDays(utcNow(outputs('Compose')),5),'MM-DD-YYYY')

I used this: addDays(formatdateTime.utcNow()(@{items('Apply_to_each')?['abc_planningdate']})),outputs('Compose')

Any recommendation will be apprecialted.

Thanks
Suggested answer

Pradeep Rai 5,482 Super User 2025 Season 1 on at

Like (0)

Report

RE: How to trigger an Opportunity by changing the estimate close date

Hi,

I tried the same, it is working as shown below:

Result:

My Findings as per your screenshot:

I can find one difference and it seems like Table Name is typed custom as Opportunity Lines using below option:

Now, if we use custom name than it shows cross sign in Table name as shown in below screenshot:

But if we use the values from list then it does not show the cross sign.

After selection

Hope this helps.

Thanks,
Pradeep.

Please mark this as VERIFIED if it helps.
Community Member on at

Like (0)

Report

RE: How to trigger an Opportunity by changing the estimate close date

Thank you for your input. I have tried your recommendation and I still get a failed Flow. I have tried using the same table name I have on the Opportunity 'Opportunity Product or Opportunity Name or and I get the same error message.
Suggested answer

Community Member on at

Like (1)

Report

RE: How to trigger an Opportunity by changing the estimate close date

Hi Lyonne2021D,

As Charan Raju C R said, you need to list opportunity products through opportunityid.

You can also use this expression:opportunityid/opportunityid eq @{triggerOutputs()?['body/opportunityid']}
Suggested answer

Charan Raju C R 7 Moderator on at

Like (0)

Report

RE: How to trigger an Opportunity by changing the estimate close date

Hi Lyonne,

If I have correctly understood your requirement, you're trying to update 'Planning Date' field in all the Opportunity Product records under an Opportunity record when 'Estimated Close Date' is changed on the opportunity.

For this, after the trigger 'When a row is added, modified or deleted' you need to add one more action 'List rows' to retrieve all the Opportunity Products related to the opportunity record. Then add 'Apply to each' action which contains 'Update a row' to update all the opportunity product records retrieved in previous step.

Refer the below screenshot for better understanding.