If statement in a Form

(0) Share

Report

Posted on by pricey79

340

Can anyone help please.

I have a form and in that form I have a toggle that toggles on a date picker. If the toggle is off, I'd like it to send the number 21 to SharePoint , if the toggle is on, I'd like it to send the datepicker selected date. There are 2 columns in SharePoint

Could anyone help please? Thank you

Categories:

Building Power Apps

All responses (13)

Answers (1)

Sort by

BrianS 2,407 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Not sure if I'm understanding correctly - a number and a date are 2 different things to SP. What is your column type that you want to right to?

You could set the default of the form field to a variable, then in the OnChange property of the DatePicker have it put the selected date into that variable. The problem is that the variable can only be one type - either a number or a date. Or do you mean that one of the columns in the SP list will hold the 21 and the other the date?
Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@pricey79

In the Update property of the card containing the toggle, If(Toggle.Value,DatePicker.SelectedDate,21)
pricey79 340 on at

Like
a
(0)

Report
Copy link

Link copied!

@BrianS thank you for your reply. Sorry, one column is a single line of text and one is a date.
So yes you are correct, if its the date, put it in the date column, if not, put it in the text column
BrianS 2,407 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

In that case you could put an If in the Update property of the Toggle

If(Self.Value,"",21)

and then have the Date Picker right to the SP list normally. I would add a default to the Date Picker of Today() in an if statement - If(Toggle.Value, Today()) - that way it will not have a value unless the Toggle makes it visible
pricey79 340 on at

Like
a
(0)

Report
Copy link

Link copied!

@BrianS thank you. I'll give it a go
How would the form know what column it is updating though as the card is assigned to a column I think?
Apologies if i'm not explaining this very well

There is a data card called Datedays. In that card there is a toggle. That toggle affects the visible property of a datepicker which appears in the datacard when the toggle is on.
Have I explained that well enough?
BrianS 2,407 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Each Field on the form is assigned to a field in the data source, so you would assign the toggle to the text field and the date picker to the to the date field. The reason you don't want to set the default on the date picker all the time is because it will right that default even if it is not visible. If you don't give it a value it will not write one.
pricey79 340 on at

Like
a
(0)

Report
Copy link

Link copied!

@BrianS Thank you for your replies.
I'm still a bit confused though , sorry
When you say Field , do you mean datacard?
BrianS 2,407 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Sorry - yes the datacard is assigned to a field in the datasource by the Datefield property. The Update property is the value that will be written to that field when the Form is Submitted
pricey79 340 on at

Like
a
(0)

Report
Copy link

Link copied!

@BrianS Thank you
So if I understand you correctly. I should have 2 different datacards. One that updates the text, and one that updates the date?
I only want one of them to be submitted though. Either the date if its chosen, or the text 21 if no date is chosen

Thank you for your time so far
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

In the text datacard Update property:

If(!Toggle.Value, 21, Blank())

in the date datacard Update property:

If(Toggle.Value, DatePicker.SelectedDate, Blank())