Unanswered

Run Status Flow Toggle Question

(0) Share

Report

Posted on by tagustin2020

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

Categories:

Building Power Apps

Collection.docx

I have the same question (0)

All responses (8)

Answers (1)

WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report
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 ?

Was this reply helpful? Yes No
tagustin2020 on at

Like (0)

Report
@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

Status and Percen...

Was this reply helpful? Yes No
WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report
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)?

Was this reply helpful? Yes No
tagustin2020 on at

Like (0)

Report

@WarrenBelz

Hello Warren,

Multiple selections are turned off for both comboboxes.

Teresa

Was this reply helpful? Yes No
WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report
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 ?

Was this reply helpful? Yes No
tagustin2020 on at

Like (0)

Report

@WarrenBelz

Hello,

The Status column is a Choice column.

Teresa

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,040 Most Valuable Professional on at

Like (1)

Report
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).

Was this reply helpful? Yes No
tagustin2020 on at

Like (0)

Report

@WarrenBelz

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

Teresa

Was this reply helpful? Yes No