Patch multiple columns from multiple checbox

[amralomari]

Dears 

I've an application where user choses couple of periods, using Mr. Reza's tutorial Here I've succefully convert the drop list into checkboxes.

This application submites the data into a SP list, in that list there are durations columns (duration 1, duration 2 ...etc.)

The next step is that I want submit button to update the durations column per chosen columns; for example if the user chose "3 months & 6 months", either the 1st and the 2nd columns are updated or the 3 months & 6 months columns will be updated with a date with 3 months in advance and 6 months in advance from the chosen "incubation date".

What I used to do before is to update the future date for 1 time period (as the gif attached) using the following:-

Table( { Name: "1 Week", Days: 7 },
{ Name: "2 Weeks", Days: 14 },
{ Name: "1 Month", Days: 30 },
{ Name: "2 Months", Days: 60 },
{ Name: "3 Months", Days: 90 },
{ Name: "6 Months", Days: 180 },
{ Name: "9 Months", Days: 270 },
{ Name: "12 Months", Days: 365 },
{ Name: "24 Months", Days: 730 },
{ Name: "36 Months", Days: 1095 } )

And the following formula in the Update field in the data picker

DateValue2.SelectedDate + Time(Value(HourValue2.SelectedText.Value), Value(MinuteValue2.SelectedText.Value), 0)

Now I don’t care showing the future date but I want when the user choses 3 periods, 3 dates will be updated in the SP list.

[v-bofeng-msft · Accepted solution]

Hi @amralomari :

Do you want to get multiple items after selecting multiple options in the combo box and add these items to the data source?

If so,I've made a test for your reference:

1\My combo box (ComboBox2)

Items

Table( { Name: "1 Week", Days: 7 },
{ Name: "2 Weeks", Days: 14 },
{ Name: "1 Month", Days: 30 },
{ Name: "2 Months", Days: 60 },
{ Name: "3 Months", Days: 90 },
{ Name: "6 Months", Days: 180 },
{ Name: "9 Months", Days: 270 },
{ Name: "12 Months", Days: 365 },
{ Name: "24 Months", Days: 730 },
{ Name: "36 Months", Days: 1095 } )

2\Submit button

With(
    {
        StartDate: DateValue2.SelectedDate + Time(Value(HourValue2.SelectedText.Value),Value(MinuteValue2.SelectedText.Value),0)
    },
    ForAll(
        ComboBox2.SelectedItems As TheTabel, 
        Patch(
           YourDataSource,
           Defaults(YourDataSource),
           {
           'Incubation Date': StartDate,
           'Stability Conditions': DateAdd(StartDate,TheTabel[@Days],Days)
           }
        )
    )
)

Best Regards,

Bof

[amralomari]

Thanks a lot dear Bof

Unfortunately I had some errors when I tried to emplement the code above for the OnSelect formula

also for the close [X] icon OnVisible formula

could you please help me at these errors?

[v-bofeng-msft]

Hi @amralomari :

Q1:Unfortunately I had some errors when I tried to emplement the code above for the OnSelect formula.

Could you tell me what Checkbox3 is?Is it a Checkbox control instead of a combo box control?

Q2:also for the close [X] icon OnVisible formula

Please try 

Form1.Mode <> FormMode.New

Best Regards,

Bof

[amralomari]

Yes it's a checkbox, as below:-

Thanks for the close icon 👍

[v-bofeng-msft]

Hi @amralomari :

In the information you provided earlier, it is mentioned that you are using a combo box.

So the solution I provided is based on combo box.

I suggest you use combo box instead of check box

Best Regards,

Bof

[amralomari]

Sorry my bad, thought both will work.

Anyway I'm still facing some issues with the patch function

Could you please elaborate for a solution, thanks in advance.

[v-bofeng-msft]

Hi @amralomari :

Could you tell me the wrong information?
Could you show me the data structure of'products List'?

I think your formula may be missing some required fields:

With(
{
StartDate: DateValue2.SelectedDate + Time(Value(HourValue2.SelectedText.Value),Value(MinuteValue2.SelectedText.Value),0)
},
ForAll(
ComboBox2.SelectedItems As TheTabel,
Patch(
YourDataSource,
Defaults(YourDataSource),
{

Column1:XXX,

Column2:xxx,

'Incubation Date': StartDate,
'Stability Conditions': DateAdd(StartDate,TheTabel[@Days],Days)
}
)
)
)

Best Regards,

Bof

[amralomari]

[amralomari]

I'm very sorry, the period column was a choice column not a Date&Time, so I've changed to Date&Time and the error was solved

But the data still not patched to the list

the duration columns are "period 1" -> "period 10"