Forum Discussion
add minutes to Time/Date column
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 t...
RenPNW use DateAdd(txtNow.Text, 45 ,TimeUnit.Minutes) changing my txtNow.Text to whatever your field is called:
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
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:
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)