cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
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 ....

Helper III
Helper III

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

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

Helper III
Helper III

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

Community Support
Community Support

Hi @geoff786 :

Just call the output of compose 2 directly.

1.JPG

Best Regards,

Bof

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (8,708)