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.
Solved! Go to 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
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
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 ....
Basically looking for the calculation you made lands in the SharePoint list .
User | Count |
---|---|
88 | |
40 | |
23 | |
20 | |
16 |
User | Count |
---|---|
130 | |
50 | |
48 | |
35 | |
26 |