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

View solution in original post

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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Kudoed Authors
Users online (3,867)