Generate The next Entries In Sharepoint

[jamescosten]

I would like to create multiple entries in a sharepoint list using various functions in the image below.

• Working - The orange box is returning the last enrtry in the Tool Number column and the time it was created.
• Working - The Red Box is shown the LASTN based upon the slider control. I will have this be hidden untill the button is pressed and then it will show the New Numbers.
• User Entry - I want the operator to request a number of new tools, and assign a customer name. THe customer name column will be populated when we generate the new Tool Numbers and the Slider controls how many entries to create.
• Need Help with - When we press the button i would like to create x number of entries in Sharepoint based upon the Slider Value and fill in the Customer column when creating them. The Tool number column is not the ID Field and is a Text Column.

I might be making this more difficult then is required and perhaps there is an easier solution?

[jamescosten]

[v-bofeng-msft]

Hi @jamescosten ,

Please try:

ForAll(
    Sequence(Slider1.Value,1,1),
    Patch(
        DataSource,
        Defaults(DataSource),
        {Title:Textinput.Text}
    )
)

Best Regards,

Bof

[jamescosten]

That works in that it creates new entries, however the word i put in the textinput made the Tool Number Field text and not the owner.

I need it to allocate the next numbers in the list so for example:

Last Tool Number is T100 and i need 2 more so i expect the two Tools to become T101 & T102 and both entries will have the textinput as the owner on both to be the same.

[v-bofeng-msft · Accepted solution]

Hi @jamescosten ,

Please try:

ForAll(
    Sequence(Slider1.Value,0,1),
    Patch(
        DataSource,
        Defaults(DataSource),
        {
         Title:Textinput.Text,
         Num:"T"&Text(100+Value)
        }
    )
)

Best Regards,
Bof

[jamescosten]

I get this error on the ampersand

[jamescosten]

Hi Ignore my last i forgot to change the Title. It now works

[jamescosten]

I thought it was working. It should be taking the last entry and adding the next numbers. But once i press the botton again it creates no new records. Only tries to recreate T100 & T101 again instead of T102&T103

[jamescosten]

@v-bofeng-msft any further thoughts?