In Microsoft Flow how do I grab an excel column and format as time for an email alert?How do I correctly use Microsoft flow conditionals with a YES/NO Columnin A sharepoint list?Using Flow with SharePoint Discussion BoardsMicrosoft Flow - Document ApprovalMicrosoft flow not filtering SharePoint list by date to send emailInsert Rows from SharePoint List into Excel in Order Using Microsoft FlowSend Outlook Email One Hour prior to SharePoint Calendar Event using Microsoft FlowCreate a new 'Job ID' based on item ID in Sharepoint listsUsing OData Filter Query to get open items with past due date from Sharepoint list using Microsoft FlowFlow will Create File in Sharepoint from an Outlook attachment but will not complete Update Files Property action
Plagiarism or not?
Personal Teleportation: From Rags to Riches
Am I breaking OOP practice with this architecture?
Short story with a alien planet, government officials must wear exploding medallions
Determining Impedance With An Antenna Analyzer
Expand and Contract
Why didn't Boeing produce its own regional jet?
Is it acceptable for a professor to tell male students to not think that they are smarter than female students?
Why is this clock signal connected to a capacitor to gnd?
How do I gain back my faith in my PhD degree?
I would say: "You are another teacher", but she is a woman and I am a man
What reasons are there for a Capitalist to oppose a 100% inheritance tax?
CAST throwing error when run in stored procedure but not when run as raw query
What are some good books on Machine Learning and AI like Krugman, Wells and Graddy's "Essentials of Economics"
How to prevent "they're falling in love" trope
Can I run a new neutral wire to repair a broken circuit?
Can we compute the area of a quadrilateral with one right angle when we only know the lengths of any three sides?
Can my sorcerer use a spellbook only to collect spells and scribe scrolls, not cast?
What does the expression "A Mann!" means
How to tell a function to use the default argument values?
How to write generic function with two inputs?
How do I handle a potential work/personal life conflict as the manager of one of my friends?
Why didn't Miles's spider sense work before?
Is it possible to create a QR code using text?
In Microsoft Flow how do I grab an excel column and format as time for an email alert?
How do I correctly use Microsoft flow conditionals with a YES/NO Columnin A sharepoint list?Using Flow with SharePoint Discussion BoardsMicrosoft Flow - Document ApprovalMicrosoft flow not filtering SharePoint list by date to send emailInsert Rows from SharePoint List into Excel in Order Using Microsoft FlowSend Outlook Email One Hour prior to SharePoint Calendar Event using Microsoft FlowCreate a new 'Job ID' based on item ID in Sharepoint listsUsing OData Filter Query to get open items with past due date from Sharepoint list using Microsoft FlowFlow will Create File in Sharepoint from an Outlook attachment but will not complete Update Files Property action
I'm trying to use Microsoft Flow to watch a Sharepoint Excel document and send an email if a certain condition is true in a table.
The email successfully contains the time column but the time looks like this: 0.569444444444444 rather than a nice formatted 13:40:00.
In my email alert this expression works to grab the value though it is formatted as 0.569444444444444...
item()?['Time Column']
When I read the documentation and try to format it nicely using this command however the Flow fails.
formatDateTime(item()?['Time Column'],'hh:mm:ss')
What am I doing wrong? Any advice? Thanks.
office365 office365-apps microsoft-flow
asked Mar 8 at 22:14
mikemike
7726
add a comment |
I'm trying to use Microsoft Flow to watch a Sharepoint Excel document and send an email if a certain condition is true in a table.
The email successfully contains the time column but the time looks like this: 0.569444444444444 rather than a nice formatted 13:40:00.
In my email alert this expression works to grab the value though it is formatted as 0.569444444444444...
item()?['Time Column']
When I read the documentation and try to format it nicely using this command however the Flow fails.
formatDateTime(item()?['Time Column'],'hh:mm:ss')
What am I doing wrong? Any advice? Thanks.
office365 office365-apps microsoft-flow
asked Mar 8 at 22:14
mikemike
7726
add a comment |
I'm trying to use Microsoft Flow to watch a Sharepoint Excel document and send an email if a certain condition is true in a table.
The email successfully contains the time column but the time looks like this: 0.569444444444444 rather than a nice formatted 13:40:00.
In my email alert this expression works to grab the value though it is formatted as 0.569444444444444...
item()?['Time Column']
When I read the documentation and try to format it nicely using this command however the Flow fails.
formatDateTime(item()?['Time Column'],'hh:mm:ss')
What am I doing wrong? Any advice? Thanks.
office365 office365-apps microsoft-flow
asked Mar 8 at 22:14
mikemike
7726
I'm trying to use Microsoft Flow to watch a Sharepoint Excel document and send an email if a certain condition is true in a table.
The email successfully contains the time column but the time looks like this: 0.569444444444444 rather than a nice formatted 13:40:00.
In my email alert this expression works to grab the value though it is formatted as 0.569444444444444...
item()?['Time Column']
When I read the documentation and try to format it nicely using this command however the Flow fails.
formatDateTime(item()?['Time Column'],'hh:mm:ss')
What am I doing wrong? Any advice? Thanks.
office365 office365-apps microsoft-flow
office365 office365-apps microsoft-flow
asked Mar 8 at 22:14
mikemike
7726
asked Mar 8 at 22:14
mikemike
7726
asked Mar 8 at 22:14
mikemike
7726
asked Mar 8 at 22:14
mikemike
7726
asked Mar 8 at 22:14
mikemike
7726
7726
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
This value 0.569444444444444 is a decimal representation for Excel time 13:40:00.
For example 0.04167 is decimal representation for 1 hour, 1.0 is equivalent of 1 day.
The point is to exctract hours, minutes and seconds from it which is not very hard but a little bit messy with built-in MS Flow functions:
split(string(mul(variables('time_decimal'),int(24))),'.')[0] returns hour
split(string(add(mul(int(60),sub(mul(variables('time_decimal'),int(24)),float(variables('hours')))),float(0.00000001))),'.')[0] returns minutes and so on.
answered Mar 13 at 16:47
nervuzznervuzz
1055
Thanks you very much for your insight. I do get the following error. It seems that the flow from excel doesn't put the column into a 'variable'. This still doesn't leave me able to access the Excel columns to calculate the time. Any suggestions?The inputs of workflow run action 'Send_me_an_email_notification' of type 'ApiConnection' are not valid. The variable 'Time Column' must be initialized before it can be used inside action 'Send_me_an_email_notification'.
– mike
Mar 14 at 0:50
1
It looks like the variableTime Columnhas not already been initialized with anInitialize variableaction
– nervuzz
Mar 14 at 6:44
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55071744%2fin-microsoft-flow-how-do-i-grab-an-excel-column-and-format-as-time-for-an-email%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
This value 0.569444444444444 is a decimal representation for Excel time 13:40:00.
For example 0.04167 is decimal representation for 1 hour, 1.0 is equivalent of 1 day.
The point is to exctract hours, minutes and seconds from it which is not very hard but a little bit messy with built-in MS Flow functions:
split(string(mul(variables('time_decimal'),int(24))),'.')[0] returns hour
split(string(add(mul(int(60),sub(mul(variables('time_decimal'),int(24)),float(variables('hours')))),float(0.00000001))),'.')[0] returns minutes and so on.
answered Mar 13 at 16:47
nervuzznervuzz
1055
Thanks you very much for your insight. I do get the following error. It seems that the flow from excel doesn't put the column into a 'variable'. This still doesn't leave me able to access the Excel columns to calculate the time. Any suggestions?The inputs of workflow run action 'Send_me_an_email_notification' of type 'ApiConnection' are not valid. The variable 'Time Column' must be initialized before it can be used inside action 'Send_me_an_email_notification'.
– mike
Mar 14 at 0:50
1
It looks like the variableTime Columnhas not already been initialized with anInitialize variableaction
– nervuzz
Mar 14 at 6:44
add a comment |
This value 0.569444444444444 is a decimal representation for Excel time 13:40:00.
For example 0.04167 is decimal representation for 1 hour, 1.0 is equivalent of 1 day.
The point is to exctract hours, minutes and seconds from it which is not very hard but a little bit messy with built-in MS Flow functions:
split(string(mul(variables('time_decimal'),int(24))),'.')[0] returns hour
split(string(add(mul(int(60),sub(mul(variables('time_decimal'),int(24)),float(variables('hours')))),float(0.00000001))),'.')[0] returns minutes and so on.
answered Mar 13 at 16:47
nervuzznervuzz
1055
Thanks you very much for your insight. I do get the following error. It seems that the flow from excel doesn't put the column into a 'variable'. This still doesn't leave me able to access the Excel columns to calculate the time. Any suggestions?The inputs of workflow run action 'Send_me_an_email_notification' of type 'ApiConnection' are not valid. The variable 'Time Column' must be initialized before it can be used inside action 'Send_me_an_email_notification'.
– mike
Mar 14 at 0:50
1
It looks like the variableTime Columnhas not already been initialized with anInitialize variableaction
– nervuzz
Mar 14 at 6:44
add a comment |
This value 0.569444444444444 is a decimal representation for Excel time 13:40:00.
For example 0.04167 is decimal representation for 1 hour, 1.0 is equivalent of 1 day.
The point is to exctract hours, minutes and seconds from it which is not very hard but a little bit messy with built-in MS Flow functions:
split(string(mul(variables('time_decimal'),int(24))),'.')[0] returns hour
split(string(add(mul(int(60),sub(mul(variables('time_decimal'),int(24)),float(variables('hours')))),float(0.00000001))),'.')[0] returns minutes and so on.
answered Mar 13 at 16:47
nervuzznervuzz
1055
This value 0.569444444444444 is a decimal representation for Excel time 13:40:00.
For example 0.04167 is decimal representation for 1 hour, 1.0 is equivalent of 1 day.
The point is to exctract hours, minutes and seconds from it which is not very hard but a little bit messy with built-in MS Flow functions:
split(string(mul(variables('time_decimal'),int(24))),'.')[0] returns hour
split(string(add(mul(int(60),sub(mul(variables('time_decimal'),int(24)),float(variables('hours')))),float(0.00000001))),'.')[0] returns minutes and so on.
answered Mar 13 at 16:47
nervuzznervuzz
1055
answered Mar 13 at 16:47
nervuzznervuzz
1055
answered Mar 13 at 16:47
nervuzznervuzz
1055
answered Mar 13 at 16:47
nervuzznervuzz
1055
1055
Thanks you very much for your insight. I do get the following error. It seems that the flow from excel doesn't put the column into a 'variable'. This still doesn't leave me able to access the Excel columns to calculate the time. Any suggestions?The inputs of workflow run action 'Send_me_an_email_notification' of type 'ApiConnection' are not valid. The variable 'Time Column' must be initialized before it can be used inside action 'Send_me_an_email_notification'.
– mike
Mar 14 at 0:50
1
It looks like the variableTime Columnhas not already been initialized with anInitialize variableaction
– nervuzz
Mar 14 at 6:44
add a comment |
Thanks you very much for your insight. I do get the following error. It seems that the flow from excel doesn't put the column into a 'variable'. This still doesn't leave me able to access the Excel columns to calculate the time. Any suggestions?The inputs of workflow run action 'Send_me_an_email_notification' of type 'ApiConnection' are not valid. The variable 'Time Column' must be initialized before it can be used inside action 'Send_me_an_email_notification'.
– mike
Mar 14 at 0:50
1
It looks like the variableTime Columnhas not already been initialized with anInitialize variableaction
– nervuzz
Mar 14 at 6:44
Thanks you very much for your insight. I do get the following error. It seems that the flow from excel doesn't put the column into a 'variable'. This still doesn't leave me able to access the Excel columns to calculate the time. Any suggestions?
The inputs of workflow run action 'Send_me_an_email_notification' of type 'ApiConnection' are not valid. The variable 'Time Column' must be initialized before it can be used inside action 'Send_me_an_email_notification'.– mike
Mar 14 at 0:50
Thanks you very much for your insight. I do get the following error. It seems that the flow from excel doesn't put the column into a 'variable'. This still doesn't leave me able to access the Excel columns to calculate the time. Any suggestions?
The inputs of workflow run action 'Send_me_an_email_notification' of type 'ApiConnection' are not valid. The variable 'Time Column' must be initialized before it can be used inside action 'Send_me_an_email_notification'.– mike
Mar 14 at 0:50
1
1
It looks like the variable
Time Column has not already been initialized with an Initialize variable action– nervuzz
Mar 14 at 6:44
It looks like the variable
Time Column has not already been initialized with an Initialize variable action– nervuzz
Mar 14 at 6:44
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55071744%2fin-microsoft-flow-how-do-i-grab-an-excel-column-and-format-as-time-for-an-email%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
