• 0 Posts
  • 43 Comments
Joined 1 year ago
cake
Cake day: June 10th, 2023

help-circle



  • I just use Chat-GPT, I also have the capability to write my own formulas, but especially for more complex or repetitive formulas it’s faster.

    Here’s one for PowerApps I asked it to extend

    Patch(Timesheets, LookUp(Timesheeets, ID=SharePointIntegration.SelectedListItemID), {DataString:Concatenate(TextInput1.Text, “;”,TextInput2.Text, “;”, TextInput3.Text, “;”, TextInput1_1.Text, “;”,TextInput2_1.Text, “;”, TextInput3_1.Text, “;”, TextInput1_2.Text, “;”,TextInput2_2.Text, “;”, TextInput3_2.Text, “;”, TextInput1_3.Text, “;”,TextInput2_3.Text, “;”, TextInput3_3.Text, “;”, TextInput1_4.Text, “;”,TextInput2_4.Text, “;”, TextInput3_4.Text, “;”, TextInput1_5.Text, “;”,TextInput2_5.Text, “;”, TextInput3_5.Text, “;”, TextInput1_6.Text, “;”,TextInput2_6.Text, “;”, TextInput3_6.Text, “;”)}); Refresh(‘Timesheets’);

    I just gave it the first bit and two text input fields initially and then asked it to add the remainder for me instead of hitting copy paste and changing the numbers a dozen times.

    Probably saved me 5 minutes, but I do this kind of thing fairly regularly so it’s probably saving me a half-hour to an hour per week on formulas alone.