Formula for Counting Days between dates via ms forms|calendar selector

[geoff786]

MS form to sp flow, two questions are being asked that can be automated, i'd like question two to run a fx off utcnow from the choice made in question 1.

any tips?

Geoff. 

1. 'When are materials needed for meeting?'- using MS Forms| date picker
2. '# of Days until Meeting';- currently a text input , would like it to be a fx based on utc now.

[v-bofeng-msft · Accepted solution]

Hi @geoff786 :

Do you want to calculate the difference between two date column values using Microsoft Flow?

I've made a test for your reference:

1\My Form

2\My Flow

Compose 2-Reference Expression

div(div(mul(sub(ticks(outputs('Compose')),ticks(utcNow())),100),1000000000),86400)

The Result

Best Regards,

Bof

[geoff786]

Ok. I just built what you modelled. Now ...I have this flow to a a SharePoint list ....how do I set that up? Let me show a screen shot ....

[geoff786]

 

 

[geoff786]

Basically looking for the calculation you made lands in the SharePoint list . 

[v-bofeng-msft]

Hi @geoff786 :

Just call the output of compose 2 directly.

Best Regards,

Bof