Answered

Cannot save SharePoint Integrated form after adding formula to drop down

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a SP Inregrated form I have been working on for some time.

The form has many fields but the issue is related to a Project Complete field - Yes No slider and also a Status Drop down field .

I am adding the following formula to the Status field default(field value not card) to automatically change the status to completed when the Project Completed switch is checked. DataCardValue1 is the Project Complete slider. The Project completed switch triggers many other things.

If(Text(DataCardValue1.Value)="false",{Value:"Active"},{Value: "Completed"})

Th vlaues update fine on the form when the switch is flipped, but ...when I click the Save on the form from within the SP list, nothing happens. I also cannot change any of the exisitng forms with this formula in the Status field.

If I delete that formula, everything works fine. It took me 3 hours to figure out why my form stopped saving. I restored back 20 versions to before that formula was added and then started adding each change I made 1 at a time until the form broke.

It doesnt matter if the switch is on true or false it does not save either way.

I think this is a bug!!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

First of all, by defaule for a Yes or No column in SharePoint list, its value could only be Yes/No, not Completed/Active.

Or did you add JSON in this column when created?

Any way, if it's a choice column, then follow below steps to get this work:

In you post you said it's a slider but I guess you mean toggle according to that you only have 2 values in your formula. Add a toggle control in this choice column data card in the form, and set the Update property of this data card to:

If(Toggle1.Value=true,{Id: 1, Value: "Completed", '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"},{Id: 2, Value: "Active", '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"})

Notice that the "Id" value depends on which value is on the top when you created this column. You can check by quick editing the items and check the drop list order of this column.

And if it's a Dropdown control, just change the "Toggle1.Value" to "Dropdown1.Selected.Value" and other text accordingly.

Regards,

Mona

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

As stated in the original post, there are two fields, a Yes\No and a choice field. The choice field has the Active and Completed options.

I started with the formula you suggested below but it was throwing an error. After I modified it, everything was working except for the save.

I have updated the drop down data card value to the following to resolve the issue:

If(EventEditForm.Mode = New, {'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id:0, Value:"Active"},ThisItem.Status)

And then used a Flow associated with the list to set the status drop down to Completed when the YES NO field is set to Yes.

Thanks for the reply.

Was this reply helpful? Yes No