add minutes to Time/Date column

Copper Contributor

Hi,

I am still looking for help on a formula that will allow me to add 45 minutes to a Time/Date column on a powerapps form.  The user selects the date and time and I need to have 45 minutes added to that time.

 

I have a calculated column but I think I will replace that with a text label, but either way can't figure out how to add the time.

 

The time/date column- Diversion ON_DataCard2

Calculated column - Diversion Comm Time_DataCard1

 

Thanks for the help!

 

Ren

 

3 Replies

@RenPNW use DateAdd(txtNow.Text, 45 ,TimeUnit.Minutes) changing my txtNow.Text to whatever your field is called:

 

DateAdd.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

Thanks Rob but no matter what I try I can't seem to get the formula to work.
here is the formula that I am using:
DateAdd('Diversion ON_DataCard2',45,TimeUnit.Minutes)
the Date and Time are user inputs and I tried the formula on a calculated column and a text label and I can't get either to accept the formula. I am not that experienced with Sharepoint Power app formulas, it is probably something that is an easy fix but I cannot figure it out.

Ren

@RenPNW Don't add it to the data card, it needs to be added to the value field inside the data card:

DateAdd-Form.png

 

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)