cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
geoff786
Helper III
Helper III

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

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.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

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

1.JPG

2\My Flow

2.JPG

Compose 2-Reference Expression

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

The Result

37.gif

Best Regards,

Bof

View solution in original post

5 REPLIES 5
v-bofeng-msft
Community Support
Community Support

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

1.JPG

2\My Flow

2.JPG

Compose 2-Reference Expression

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

The Result

37.gif

Best Regards,

Bof

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
Helper III
Helper III

24ED00F9-BC6D-417E-BC17-5940B715843D.jpeg

FE90EF9C-77D1-4C9D-8671-EDE66217D080.jpeg

geoff786
Helper III
Helper III

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

v-bofeng-msft
Community Support
Community Support

Hi @geoff786 :

Just call the output of compose 2 directly.

1.JPG

Best Regards,

Bof

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (1,481)