Unanswered

Custom Dialog to Set Status Value

(0) Share

Report

Posted on by CCJones

244

I have a SharePoint list that is used to collect support requests. I have created a custom PowerApps form and am trying to add a custom dialog that pops up when the "Submission Status" selected value is "Draft". The pop-up opens and informs the user that their request is still in Draft status and asks if they want to Submit it now or save it as a draft. I added two buttons, one for Submit and one for Save as Draft. When they click "Submit", I need the Submission Status value to change to "Submitted". The only two options are "Draft" and "Submitted". If they click "Save as Draft" it just saves the form and closes. The "Save as Draft" is no problem. I can't get the "Submit" button to set the "Submission Status" value to "Submitted".

Here are the formulas I have used so far:
Custom Save button OnSelect on main form

If(
SubmissionStatusValue.Selected.Value = "Draft", 
UpdateContext({showDialog:true}), 
SubmitForm(SharePointForm1))

If the selected submission status is "Draft", set the variable showDialog to True, otherwise submit the form.

Submit button OnSelect in dialog group

UpdateContext({varSubmissionStatus: "Submitted"});
UpdateContext({showDialog: false});
SubmitForm(SharePointForm1);

Set the variable varSubmissionStatus to "Submitted", set the variable showDialog to false and submit the form.

grpShowDialog (consists of all elements in the pop-up dialog) Visible parameter

showDialog

SubmissionStatusValue ComboBox DefaultSelectedItems parameter

If(
SharePointForm1.Mode = FormMode.New, 
LookUp(Choices('M&D SharePoint Support Requests'.'Submission Status'), Value = "Draft"), If(
showDialog, 
LookUp(Choices('M&D SharePoint Support Requests'.'Submission Status'), Value = varSubmissionStatus), 
Parent.Default))

If form mode is new, set the default Submission Status value to Draft. Otherwise, if the showDialog variable is true, set the default Submissions Status value to the value of varSubmissionStatus which should have been set to "Submitted" if the Submit dialog button was clicked. Otherwise, set the default to the parent default.

This does not work. The Submission Status remains "Draft".

Any ideas what I'm doing wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

BlessedCobba 459 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@CCJones

The default property on a ComboBox is not constantly evaluated throughout the app, it will evaluate it once when the screen is loaded and that is it. to update it, so you cant use things like If statements in that property but you are close to the answer.

Set the Default property of the dropdown to varSubmissionStatus

Move your If statement to the onStart or onVisible Property, and instead of modifying the default property, you modify the variable. eg. if form new, set variable to draft, if not new, lookup parent value.

then your submit button essentially stays the same where you update the variable to submitted

the difference doing it this way is the Default property is just set to the value of the variable and not evaluating an IF statement, so when the variable updates, it triggers the default property to change.

Was this reply helpful? Yes No
CCJones 244 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the response. I tried your suggestion but the Default field won't accept the "varSubmissionStatus" variable because it contains text and not a record. I get an error that it is expecting a record. I can't use a record value primarily because the selected value from the "SubmissionStatusValue" combobox is what I need to check and update if the user chooses the "Submit" button on the pop-up dialog. In the form, I am using the UpdateContext function to make changes to the variables (varSubmissionStatus and showDialog). You had mentioned using the OnVisible property of the form to set variables, but it won't let me use UpdateContext there. I tried using Set, but that didn't work.

This is all so ridiculously complicated. I never had this kind of trouble when I was using Nintex for building solutions. Our company went to SP Online and dumped Nintex, so I'm stuck with the Power Platform. Not being a developer makes it a lot more difficult for me. I feel like I'm so close to having it, but I just can't figure out the final bit which is populating the "SubmissionStatusValue" combobox with "Submitted" and saving that value if they click the "Submit" button. All my other controls work as expected. The pop-up opens if "SubmissionStatusValue.Selected.Value = "Draft". It saves as "Draft" if the user clicks the "Save as Draft" button because nothing has to be done but submit the form. It's just this pop-up dialog "Submit" button that is giving me nothing but headaches.

Was this reply helpful? Yes No
CCJones 244 on at

Like (0)

Report
Copy link

Link copied!

I've changed all the UpdateContext functions to Set functions and have it working to the same point I had it previously. Still can't update the SubmissionStatusValue.Selected.Value programmatically with a button click.

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

Like (0)

Report
Copy link

Link copied!
Hi @CCJones

I've done some playing around and have been able to get a dropdown to update,
I have a few values that are in my dropdown from a data source. i noticed updating the default variable also doesn't trigger a change so I have had to update the variable to set the default and then trigger a reset of the dropdown

three properties for my dropdown are required for this to work

Items:
//get items from a sharepoint list Filter(SmartScores,Question = 3)
Default:
vcom
Reset:
myVar

Then I have the button
If(Dropdown4.Selected.Title = "No more than 5", UpdateContext({vcom: "Between 5 and 10"}) && UpdateContext({myVar:true})); UpdateContext({myVar:false})

Was this reply helpful? Yes No
CCJones 244 on at

Like (0)

Report
Copy link

Link copied!

Thank you for this! I am not able to test right now, but will try to do so early next week.

Was this reply helpful? Yes No
CCJones 244 on at

Like (0)

Report
Copy link

Link copied!
Hi, tried this and couldn't get it to work either. the Default property gives me an error that it is expecting a record when I apply the variable to it. It won't accept the text value that is stored. My Items is different than yours since it is looking up the values available from the choice column it is associated with:

Choices([@'SharePoint Support Requests'].'Submission Status')
Clearly, my "Items" property is pulling a record, so it expects a record from the variable. Am I going to have to make a lookup list or a collection that contains the choice values instead of using a choice column?

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

Like (0)

Report
Copy link

Link copied!
@CCJones

I've tried it with choices as well and I'm not getting an error

I changed the items property on my dropdown to
Choices([@CommunityTest].Status)

And my Button

If(Dropdown4.Selected.Value = "Submitted", UpdateContext({vcom: "Draft"}) && UpdateContext({myVar:true})); UpdateContext({myVar:false})

Was this reply helpful? Yes No