welcome.
scenario is quite simple, but i am quite new to MS Flow.
Dynamics 365 Crm, Invoice Entity.
We have fields:
when Condition is met i want to add a fields into a Date Time field: Invoice Date + Days Until Payment + 3 extra days.
i am not able to add those fields.
thanks for help
Solved! Go to Solution.
Hi @Toms,
You can have a try with the following configuration.
I used fields of SharePoint instead, and create fields Day Until Payment, Invoice Date and Delay Date in a list.
Day Until Payment, Number;
Invoice Date, Date time;
Delay Date, Date time.
And your requirement is that adding the sum of "Invoice Date + Days Until Payment + 3 extra days" into field Delay Date. You can reference to these functions:
Step1: Get the result of the sum of "Day Unitil Payment" and "3", and convert them from floating to integer.
int(add(triggerBody()?['DayUntilPayment'],3))
Step2: Add the function addDays(InvoiceDate,integer,Format of Date)
addDays(triggerBody()?['InvoiceDate'],outputs('Compose'),'MM-dd-yyyy')
Step3: Add the result into your field Delay Date or other name.
You can put the function in the Expression.
Please have a try with it and I hope it will help you.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Toms,
You can have a try with the following configuration.
I used fields of SharePoint instead, and create fields Day Until Payment, Invoice Date and Delay Date in a list.
Day Until Payment, Number;
Invoice Date, Date time;
Delay Date, Date time.
And your requirement is that adding the sum of "Invoice Date + Days Until Payment + 3 extra days" into field Delay Date. You can reference to these functions:
Step1: Get the result of the sum of "Day Unitil Payment" and "3", and convert them from floating to integer.
int(add(triggerBody()?['DayUntilPayment'],3))
Step2: Add the function addDays(InvoiceDate,integer,Format of Date)
addDays(triggerBody()?['InvoiceDate'],outputs('Compose'),'MM-dd-yyyy')
Step3: Add the result into your field Delay Date or other name.
You can put the function in the Expression.
Please have a try with it and I hope it will help you.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
92 | |
44 | |
21 | |
18 | |
16 |
User | Count |
---|---|
137 | |
49 | |
42 | |
37 | |
29 |