Hi
basically i need to check if the date from sharepoint column(ReservedForTomorrow) is equal to todays date and if it is then copy/ that date to other column called ReservedFor. current code that doesn't run
Patch(Filter('Parking - Products'; StartsWith(Text(ReservedForTomorrow); Datenow)); {ReservedFor:Today()+23})
DateNow is a variable with todays date
i'm not a proffesional in this area and have been trying to fix it for days 😞
Solved! Go to Solution.
@Keit While patching, one column can't refer to a value from another column in the SP list. You have to supply the value. If you don't have this value in the APP, you can use the record that the 1st patch returns and then do another patch with the value that's in it.
Set(patchedRecord, Patch('Parking - Products'; LookUp('Parking - Products'; ReservedForTomorrow=Today()); {ReservedFor:Today()}));
Patch('Parking - Products'; patchedRecord; reservedbytomorrow:patchedRecord.reservedby})
@Keit Try this,
Patch('Parking - Products', LookUp('Parking - Products', ReservedForTomorrow=Today()), {ReservedFor:Today()+23})
sadly that didn't update that reservedfor
date and time
Thanks this worked, had to change the date codes on all screens.
another question how would i be able to patch text columns that conatin emails too, code that i tried below didn't accept it
Patch('Parking - Products', LookUp('Parking - Products', ReservedForTomorrow=Today()), {ReservedFor:Today()};{reservedbytomorrow:reservedby})
@Keit when you want to patch multiple fields, separate them with a comma,
Patch('Parking - Products', LookUp('Parking - Products', ReservedForTomorrow=Today()), {ReservedFor:Today(), reservedbytomorrow:reservedby})
Please remember to give a 👍 and accept the solution as it will help others in the future.
the last one only lets me choose datacards not the column value
@Keit I'm not quite sure what you mean by that. If you have a TextInput that has the email, you will have to write, my TextInput.Text
Hope that helps.