Answered

Dates

(0) Share

Report

Posted on by Ramole Super User 2024 Season 1

Hi All,

I wonder if this is possible i have a form and Repeating gallery all i need is when payment frequency dropdown is select monthly the repeating gallery should auto calculate and create 4 lines filled due dates for me at moment i am using this formula and it does creates for me lines :

Could you please try this?

1. Set App.OnStart: ClearCollect(ColNum,[1,2,3,4,5,6,7,8,9,10])

2. Modify the OnChange of Number Package Textinput box as below, it creates new rows repeatedly based on the values you enter.

ForAll(
FirstN(ColNum,Value(DataCardValue60_2.Text)),
Collect( NewShipCollection,
{CItemSerialNumber: Text(Last(NewShipCollection).CItemSerialNumber + 1),
Clevel: "",
Ctc: "",
Cdescription: ""
}))

also screenshot

date set.png

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Ramole :
The point is using switch function.
I've made a test for your reference:
1\Add a data picker control(DatePicker1)
2\Add a drop down control(Dropdown1)
Items:

["Weekly","Monthly","Daily","Annual"]

3\Set the DataCardValue60_2's OnChange porperty to:

ForAll( FirstN( ColNum, Value(DataCardValue60_2.Text) ), Collect( NewShipCollection, { CItemSerialNumber: Text(Last(NewShipCollection).CItemSerialNumber + 1), 'Due Date': Switch( Dropdown1.SelectedText.Value, "Weekly", DateAdd( DatePicker1.SelectedDate, Value(Last(NewShipCollection).CItemSerialNumber + 0) * 7, Days ), "Daily", DateAdd( DatePicker1.SelectedDate, Value(Last(NewShipCollection).CItemSerialNumber + 0), Days ), "Monthly", DateAdd( DatePicker1.SelectedDate, Value(Last(NewShipCollection).CItemSerialNumber + 0), Months ), "Annual", DateAdd( DatePicker1.SelectedDate, Value(Last(NewShipCollection).CItemSerialNumber + 0), Years ) ), Clevel: "", Ctc: "", Cdescription: "" } ) )

Best Regards,
Bof

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft

I have tried the code but i get blank on the gallery when i select the dates and payment frequency and number loan dropdown the on change code is on the number of loans dropdown as it collections but the gallery returns blank, here the code which i have modified a bit

ForAll(
FirstN(
ColNum,
Value(DataCardValue45.Selected.Value)
),
Collect(
NewLoansCollection,
{
CItemSerialNumber: Text(Last(NewLoansCollection).CItemSerialNumber + 1),
LoanDueDate: Switch(
DataCardValue8.Selected.Value,
"Weekly",
DateAdd(
DatePicker3.SelectedDate,
Value(Last(NewLoansCollection).CItemSerialNumber + 0) * 7,
Days
),
"Daily",
DateAdd(
DatePicker3.SelectedDate,
Value(Last(NewLoansCollection).CItemSerialNumber + 0),
Days
),
"Monthly",
DateAdd(
DatePicker3.SelectedDate,
Value(Last(NewLoansCollection).CItemSerialNumber + 0),
Months
),
"Annual",
DateAdd(
DatePicker3.SelectedDate,
Value(Last(NewLoansCollection).CItemSerialNumber + 0),
Years
)
),
Clevel: "",
Ctc: "",
Cdescription: ""
}
)
)

;Set(HideForm4,true);Set(HideForm3,false)

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Ramole
please try
DataCardValue8.SelectedText.Value
instead of
DataCardValue8.Selected.Value
Best Regards,
Bof

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft

Thanks it was ColNum wrong, the correct one was ColNumb, that solved, can the switch handle calculation ? example if the loan amount is $2000 and i select dropdown monthly and numbers of months is 4 can it auto calculate and fill amount field like $500 each month depending how months i select? if yes please help me with formula.

Thank you so much.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Ramole :
Can you describe your calculation logic in detail? I don’t quite understand. If the total loan is 1,000 and it will be changed in 4 months, why is it 500 per month?
Best Regards,
Bof

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft

Sorry i was wrong i mean $2000, i have edited the post.
Thanks

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Ramole :
1\Add a text input control(TextInput1)
2\Then try this code:
ForAll(
    FirstN(
        ColNum,
        Value(DataCardValue60_2.Text)
    ),
    Collect(
        NewShipCollection,
        {
            CItemSerialNumber: Text(Last(NewShipCollection).CItemSerialNumber + 1),
            'Due Date': Switch(
                Dropdown1.SelectedText.Value,
                "Weekly",
                DateAdd(
                    DatePicker1.SelectedDate,
                    Value(Last(NewShipCollection).CItemSerialNumber + 0) * 7,
                    Days
                ),
                "Daily",
                DateAdd(
                    DatePicker1.SelectedDate,
                    Value(Last(NewShipCollection).CItemSerialNumber + 0),
                    Days
                ),
                "Monthly",
                DateAdd(
                    DatePicker1.SelectedDate,
                    Value(Last(NewShipCollection).CItemSerialNumber + 0),
                    Months
                ),
                "Annual",
                DateAdd(
                    DatePicker1.SelectedDate,
                    Value(Last(NewShipCollection).CItemSerialNumber + 0),
                    Years
                )
            ),
            Clevel: "",
            Ctc: "",
            Cdescription: "",
            'loan amount': Value(TextInput1.Text) / Value(DataCardValue60_2.Text)
        }
    )
)
Best Regards,
Bof

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much @v-bofeng-msft

Was this reply helpful? Yes No