How to Submit the same form multiple times

[rgparisoto]

Hello friends!

I need to submit the same information from a form, that have two fields that I have to change, for example:

Date - Value - Obs.

01/01/2018 - $ 50.00 - Part 01/10

01/02/2018 - $ 50.00 - Part 02/10

01/03/2018 - $ 50.00 - Part 03/10

01/04/2018 - $ 50.00 - Part 04/10

01/05/2018 - $ 50.00 - Part 05/10

01/06/2018 - $ 50.00 - Part 06/10

01/07/2018 - $ 50.00 - Part 07/10

01/08/2018 - $ 50.00 - Part 08/10

01/09/2018 - $ 50.00 - Part 09/10

01/10/2018 - $ 50.00 - Part 10/10

Does anyone have an idea to submit this information junt one time, and changing only the fields Date and Obs, instead of submit one by one?

Thank you.

[v-monli-msft]

Hi @rgparisoto,

To add days to all records in a column, you could use the ForAll and DateAdd function. For example, you could add 1 day to Date column of all the records using a similar formula like below:

ForAll(Table1,Text( DateAdd( Date, 1, Days ),"[$-en-US]dd-mm-yyyy" ))

But the Obs column, since it contains a text "Part", it cannot be treated as date in PowerApps, so this column I think it cannot use the DateAdd to add days.

For your reference:

DateAdd

https://docs.microsoft.com/en-us/powerapps/functions/function-dateadd-datediff

ForAll

https://docs.microsoft.com/en-us/powerapps/functions/function-forall

Regards,

Mona

[Sienna]

Oh really.. Why don't you tell about the timer...monli??... Yes the answer to your question is timer but I got to warn you... it is very tricky to set it up and very messy due to lack of "for loop" code in the powerapps wich was also suggested since 2 years ago. Oh... BTW this works as far as i know with collection... I don't know if geniuses from microsoft also thougt about this kinda situation in connection but I asume from monli answer I don't think so... So in other words you're screw here

Good luck

[rgparisoto]

Thank you Mona!

I'll take a look and come back to tell you.

[Anonymous]

Hi. Late to the party but what the heck. Let's do this. lol

@Sienna -- there isn't really any need for a Timer object here. We just need to iterate from 1 to 10.

@v-monli-msft -- We can do better!

Since we can't iterate in PA (because there's no for loop, unfortunately), we can define a range of numbers and use that as an iterator. One limit to this method is that you'll be limited to a specific number of iterations. 

The code could look something like this with the following assumptions:

1. The Value stays the same across all days. For clarity, let's call the textbox control, ValueInput.
2. The value of the Date Control is the first day. Let's call that control, DateInput. 
   Disclaimer though: I haven't worked with dates in PA because PA timezone handling confuses the heck out of me. All that implicit conversions. *Shudders*
3. All the records to be included are NEW records. That's where the Defaults() function comes in.
4. We're submitting the form ourselves. i.e. We're not using SubmitForm() but rather using Patch(). I'm going to use YourDataSource for the name of, well, your data source because I don't know what it is.

So, the code!

UpdateContext({
    Numbers: [1, 2, 3, 4, 5, 6, 7, 8, 9, 10]
});
ForAll( Numbers,
    Patch( YourDataSource, Defaults(YourDataSource), {
        Date: Text( 
            DateAdd( DateInput.SelectedDate, Value - 1, Days ),
            "[$-en-US]mm/dd/yyyy"
        ),
        Value: ValueInput.Text,
        Obs: "Part " & Text(Value, "00") & "/" & Text( Last(Numbers).Value )
    })
)

I haven't tested it but the code should look like this. Or something. Lemme know if this helps. Or not. Good luck!

Edit: Minor typos.

[Anonymous]

So, I don't have a convenient data source to test against but I can display the contents with a similar formatting. The code's going to be different but the underlying logic should be the same. So, here it is.

Objects Needed:

1. A Screen (duh.) We'll use the OnVisible property of the screen to create our table/range/iterator called Numbers.
2. A Date Picker called DateInput
3. A Text Input called ValueInput
4. A Label to show the output.

Code:

• Screen.OnVisible
  

  UpdateContext({ Numbers: [1,2,3,4,5,6,7,8,9,10] })

• Label.Text
  

  Concat( Numbers,
      Text( 
          DateAdd( DateInput.SelectedDate, Value - 1, Days ),
          "[$-en-US]mm/dd/yyyy"
      ) & " " & 
      ValueInput.Text & " " 
      & "Part " & Text(Value, "[$-en-US]00") & "/" & Text( Last(Numbers).Value ) & Char(13) & Char(10)
  )

  The Concat() function replaces the ForAll() and Patch() function when displaying.

Screenshots!

 

[Sienna]

TheLoneWoof

Yeah.. good... I like that... looks like another way of doing it. (To PA.. That doesn't mean we don't need loop function!!!) It might get a bit tricky and it is a bit limited but still ... thumbs up. Just to get all options in one place I'm posting the timer option what we used to do back in "Sinnna times". We might lough about this options in 10 years time when loop will be finally added in sienna 😄

[Anonymous]

@Sienna --

I do think, in some cases, being able to use a loop would be better. My implementation is limited in the sense that there would be always 10 records added and changing that number would require change the source code. But PA is determined to be no-code so having loops looks very unlikely.

Although, I do really like what you did with the Timer object. That functions more like a loop. Potentially, you can control the number of iterations it would make by adding a counter control and referencing the value of that control in the Repeat property.

The only issue I can think of right now is when OnTimerStart doesn't increment its iterator before the next loop runs. I believe that could be considered undefined behavior as there's nothing comprehensive (that I could find, that is) about Timer behavior in the documentation. Will Repeat wait until the previous loop's OnTimerStart code is done executing or will it just bull through? A Patch() function may take a while to execute. Although, I may be thinking too deep on this one.

In any case, great job with the Timer. 😄

[rgparisoto]

Excelent @Anonymous!

For example, can I put a text label field to change the number of loops that my submit form will send new information?

Because sometimes I'll have 10, another, 5, or 3, etc.

Is it possyble?

Thank you.

[rgparisoto]

Guys, my form is like this:

To understand:

- DataMovimento will change, I'll increase one month (Brazil date type);

- Número, Conta, Fornecedor, Categoria, Subcategoria, Valor and Compensado will be the same all times;

- Observações I'll put that information 01/10, 02/10, 03/10, etc. (It's like when someone buy me something and want to pay for me in 10 months (or more));

- In the field Repetições (repetitions) I'll put the number of months I want to repeat, os save in the database.

Can I use you script model to send it with the bottom OnSelect (SubmitForm(MovimentaçõesIncluiForm) ;; Navigate(Movimentações;ScreenTransition.None))?