Change time if checkbox = true

(0) Share

Report

Posted on by wshalex123

160

Hi,

i got a flow where employees can request an absence. They add the data of their absence in a Sharepoint List, which is the trigger of my flow.

Now, i got a problem with the input time in the Sharepoint List

If you keep the time at 00:00 in Start & Ende, it shows up the wrong date in the calendar later on.

My Goal:

So i added a checkbox, where the user can select, if the absence is a whole-day absence (= In the picture above "Abwesenheit Ganztägig?") (like in outlook)

In my flow i want:

"whole-day absence" = Yes

Then

change the time of "Start" to 00:00 and of "Ende" to 24:00 (No matter which time the user selected!)

I only want to change the time, not the date!

I haven't found any action in power automate which fits my wish...

Maybe someone can help me out 🙂

Thanks a lot!

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

abm abm 32,858 Most Valuable Professional on at

Like (0)

Report

Hi @wshalex123

Try the below expressions

formatDateTime(utcNow(),'dd-MM-yyyy 00:00')

formatDateTime(utcNow(),'dd-MM-yyyy 24:00')

Change the UTCNow() to your Dynamic datetime.

Was this reply helpful? Yes No
wshalex123 160 on at

Like (1)

Report

Hey @abm ,

So you also know a solution, where you change the time in a variable in order to use it with the rest of the flow?

Like here, where i changed the timezone of the created item in the sharepoint list, i need a action where i change the time itself, not a formula.

Was this reply helpful? Yes No
abm abm 32,858 Most Valuable Professional on at

Like (0)

Report

Hi @wshalex123

Try the below

Was this reply helpful? Yes No
wshalex123 160 on at

Like (1)

Report

Hey @abm,

you solution works, but i got a problem when adding this time to ,the sharepoint calendar because of the format...

How can i change the type so i can use it as string and date?

Was this reply helpful? Yes No
abm abm 32,858 Most Valuable Professional on at

Like (0)

Report

What the datatype in SharePoint? If its string then use string() expression to convert the value.

Was this reply helpful? Yes No
Verified answer

wshalex123 160 on at

Like (0)

Report
For future visitors: here's the solution:

FYI:
Timezones are absolutly strange here, and until today i have to idea why exactly this certain timezone works for me (i have different timezones in my actions), i just tried so many different timezones until i got the correct time.

here's the flow with notes (i changed names of the action partially):

"Convert timezone"
create a custom date, with "." as delimiter.
if you type: dd, MM, YYY, hh, mm, ss, am or pm, you will get the data from the sharepoint list
00.00.00."am" is my overriten or custom manipulation of the date
"initialize variable"

1: Change data type of the "custom date"
2: Split up the "custom date"
formula:
split(variables('VarDateInString'), '.')
... '.' is the delimiter you put in the custom date in the first step
3: Combine the date again
formula:
formatDateTime(concat(variables('VarDate')[6], ' ',variables('VarDate')[3], ':',variables('VarDate')[4], ':', variables('VarDate')[3], ' ', variables('VarDate')[2], '-', variables('VarDate')[1], '-', variables('VarDate')[0]), 'MM/dd/yyyy hh:mm:ss tt')
... ' ' , ':' , '-' are the symboles between the variables (choose correctly!) -> dd-MM-yyy HH:mm tt
variables('VarDate')[6], variables('VarDate')[5], etc. is the data between the delimiter (dd, MM, etc)
the order i the opposite from the date's order! So 'VarDate')[6] = "am" and VarDate')[0] is MM
I changed the position of MM and dd here, which makes absolutly no sense, but i got the correct result

Hard to explain this topic, it cost me hours.
But maybe i can help someone with this

Was this reply helpful? Yes No