Run Status Flow Toggle Question

[tagustin2020]

@WarrenBelz 

Hello Warren,

I have a follow-up question for you to the Status/Percent Complete issue you helped me resolve today. I have a Status toggle in my form that helps determine when a flow runs that informs stakeholders of a status change. It is set to default to "No" in the SharePoint list. It should only change to "Yes" when the record is updated to a different status.

The Default property of the toggle is:

If(varRecord.Status.Value <> cbStatusES.Selected.Value, true, false)

If I hover over the first part of the formula, it displays the correct existing status.

If I hover over the second part of the formula, it is more ambiguous so the toggle trigger no longer triggers the flow.

The Items property of the Status combobox is. 

Distinct(colChoices,Value)

What adjustment do I need to make, to make this work? I have attached the Collection that is established in the OnVisible property of the screen. Let me know if you need any additional information. Thank you! Teresa

[WarrenBelz]

Hi @tagustin2020 ,

Firstly, you only need in the Default

varRecord.Status.Value <> cbStatusES.Selected.Value

however what is the DefaultSelectedItems of cbStatusES ? Also, if you put this on a Label

cbStatusES.Selected.Value

do you see the correct value ?

[tagustin2020]

@WarrenBelz 

Hello Warren,

Thank you for the simplified formula suggestion. I should have caught that. Here are the Default and DefaultSelecteditems properties for the Status combobox.

I inserted a label on the screen and set the Text property to cbStatusES.Selected.Value. It reads [object Object].

As I continue testing the app, I noticed that the color-coded status label isn't working correctly. It should state the previous status when the form is in Edit mode. This will likely resolve itself along with the toggle value once we get this worked out, but I thought I would let you know. 

The Text formula for the colored bar is:

If(varRecord.Status.Value = cbStatusES.Selected.Value, "Status: " & varRecord.Status.Value, "Previous Status: " & varRecord.Status.Value)

More importantly, the Percent Complete options aren't showing up in the Percent Complete combobox when I choose a different status from the Status combobox. This happens whether I have the OnChange of the Status ComboBox set to false or to Reset(cbPercentCompleteES).

I've attached the formulas for the OnVisible Collection and the Status and Percent Complete data cards. Let me know if there is anything else you need to troubleshoot this. Do you think this Collection method can be easily fixed or do we need to revisit the supporting Status SharePoint list I created that had the two single line of text columns to feed the Status and Percent Complete comboboxes in a cascading method?

Kind regards,

Teresa

[WarrenBelz]

Hi @tagustin2020 ,

The core of the issue is in this value

cbStatusES.Selected.Value

as it seems to be a Table - do you have the multiple select turned on (when it should not be)?

[tagustin2020]

@WarrenBelz 

Hello Warren, 

Multiple selections are turned off for both comboboxes. 

Teresa

[WarrenBelz]

Hi  @tagustin2020 

If a single selection, then 

cbStatusES.Selected.Value

should produce the text value that is selected (not [object Object] - which suggests a Table). You can also delete the Default of the Combo Boxes and leave DefaultSelectedItems.

So the next question is what type of field is Status ?

[tagustin2020]

@WarrenBelz 

Hello,

The Status column is a Choice column.

Teresa

[WarrenBelz · Accepted solution]

Hi @tagustin2020 ,

Try in the DefaultSelectedItems either

{Value: ThisItem.Status.Value}

or simply

ThisItem.Status

You are currently putting a table inside and existing Table (so going another level deep).

[tagustin2020]

@WarrenBelz 

Thank you, Warren. That worked. I appreciate your help!

Teresa