Answered

How to set form mode based on non/existence of record?

(0) Share

Report

Posted on by beejo

Hello! I have a table in a data source that has a date column. Any given date may or may not have a row associated with it.

Then I have a canvas app with a DatePicker and an associated form, Form1. I want to be able to select an arbitrary date, and if there's already a row in the data source for that date, I want to put the form in view (or potentially edit) mode; if not, I want to put the form in new mode.

How can I do this? Thanks!

(One path I've considered is setting an onchange handler on the DatePicker which would look something like "If(Form1.ThisItem, ViewForm(Form1), NewForm(Form1))" but a) ThisItem doesn't seem defined in this context and b) there's no guarantee that the load status would be accurate at control change time.

Another that seems more "Power Apps-y" would be to set a property such as Form1.Mode to If(Form1.ThisItem, FormMode.View, FormMode.New) and let the responsive engine do its thing, but I can't seem to find such a property...)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

cwebb365 3,304 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

So wherever you are setting the Item property of the form, add a ; after it, then do something like If( IsBlank( "The Item property of the form here" ) , NewForm(Form1), ViewForm(Form1))

This basically will set the formMode based on if the item exists or not.

Was this reply helpful? Yes No
beejo 32 on at

Like
a
(0)

Report
Copy link

Link copied!
So first I confess, my real case is trickier as I have two different fields I am filtering on, so Form1.Item is actually:
First( Filter('Test Table', 'Category' = Category_DropDown.SelectedText.Value, Date = Date_DatePicker.SelectedDate) )

However, even if I do the ridiculous thing (bloated, redundant, with race conditions, etc.) and change my Item to:

First( Filter('Test Table', 'Category' = Category_DropDown.SelectedText.Value, Date = Date_DatePicker.SelectedDate) ); If( IsBlank( First( Filter('Test Table', 'Category' = Category_DropDown.SelectedText.Value, Date = Date_DatePicker.SelectedDate) ) ), NewForm(Form1), EditForm(Form1) )

... NewForm() and EditForm() are red-underlined with error "Behavior function in a non-behavior property. You can't use this property to change values elsewhere in the app."

Am I completely misunderstanding you??

Was this reply helpful? Yes No
cwebb365 3,304 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Yeah, you can't set those on the Item property. I was saying use it on one of your events of your pickers, but use the same Filter to compare against to see if it returns a record. The isBlank() (it might need IsEmpty()) can't remember, is just saying if that filter that your Item property would use doesn't return anything, then set the form to NewForm(Form1) , or ViewForm(Form1).

That's kind of the basic principal.

Was this reply helpful? Yes No
beejo 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Yeeeeah, I got you. It does seem to work except for the initial load (since there's no initial change event and I guess I would have to force one), but boy does it feel clunky. I have to attach it to both pickers (redundant) and I suspect each change is making two requests to the data source, one from Form.Item and one from picker onchange (inefficient) 😞

No offense, maybe that's the best I can get. Little surprising though, it seems like a pretty common use case.

Was this reply helpful? Yes No
cwebb365 3,304 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

The only way to set a form mode is by the functions, and those only can be tied to events, so it's kind of the only way. You can set a default, but you have to call a reset each time to load the default logic anyway, I just prefer to handle the app flow manually.

To handle initial load, you can always add same logic to OnStart, if you have some kind of default record coming in. Or whatever action / event you take to get to the screen with the form.

Was this reply helpful? Yes No
beejo 32 on at

Like
a
(1)

Report
Copy link

Link copied!

I agree that events are the right place to do it. I'm just thinking, the platform makes a decision in View mode whether or not to show a record or to display "No item to show" (basically where you would expect an onLoad() handler to be) and that would be the perfect place to attach an event to switch to New mode. But if that isn't an exposed interface, I'm kinda out of luck for a low-profile solution.

Thanks for the help.

Was this reply helpful? Yes No