how to make a yes/no field on an existing field

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

In the field "next appointment",

I'd like to have the opportunity to choose whether or not there's a next appointment.

If there is a next appointment I press Yes ➡️ I have the possibility to choose the date as you can see at the moment.
If there is no next appointment I press No ➡️ a message indicating "no appointment is scheduled" is recorded.

thanks for your help,

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous

Your screenshot shows that the field is required. You must change this to not required as the field should be blank if no appt is required. Unlock the card containing the date field. Add a toggle control to the card and set the properties as follows:

FalseText: 'No future appt necessary'
TrueText: 'Make future appt'
OnCheck: 'UpdateContext({showappt:true})
Visible: !showappt
Default: false
Select all of the controls in the card and set their Visible properties to showappt

Set the OnVisible property of the screen to UpdateContext({showappt:false})

Set the OnSuccess property of the form to Reset(Toggle1)

Based on these instructions, when the screen is displayed, the toggle will show No future appt necessary. When the toggle is checked, then it will disappear and the date and time controls will become visible. Once the data in the form is saved, the toggle will reset back to No appt necessary and become visible when the screen is reopened.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

hi @Drrickryp ,

It works perfectly! 😀

Thank you for your help and your time

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp ,
I've just noticed a small detail on the other hand once I validate the form without indicating a date.

The result still shows me a date by default, should I adjust the "update" or something else not ?

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

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

You will need to change the Update property to account for a blank date. Something like

If( IsBlank(DateValue3.SelectedDate), Blank(), DateValue3.SelectedDate + Time( Value(HourValue3.Selected.Value), Value(MinuteValue3.Selected.Value), 0 ) )

Make sure you have removed the required property for the field or PowerApps will try to insert the current date and time in the field.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp ,

unfortunately the same result

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous

I think we are getting closer. Rather than mess with the Edit screen, what if you controlled the visibility in the Display form based on a date only being shown if it is in the future. I'm guessing here but what if you set the Visible property of the date item in the display screen to Date >= Today(). As an alternative, The Visible property of the card in the Display form as DateDiff(Today(),futureApptDate)>0
BTW, you shouldn't use "Date" as the name of a field because it is a reserved function in PowerApps and could lead to confusion. Something like futureApptDate would be more appropriate.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp ,

It's working!

a big thank you for your help and patience

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

Like
a
(1)

Report
Copy link

Link copied!

De rien mon ami.

Was this reply helpful? Yes No