The problem is when I display the list from a drop down I get all entries I only want to display from the choice of 4, Low, intermediate, etc. How would I Link that to SP? Do I create a choice field in SP and match it up that way?

[mezcalbean]

Hi I have a field that is based on a value or a score which in returns a text - thank you  @zmansuri 

I have created a SP field called Risk - and works well

The problem is when I display the list from a drop down I get all entries  I only want to display from the choice of 4, Low, intermediate, etc. How would I Link that to SP? Do I create a choice field in SP and match it up that way? 

With(
{input: Value(charttxt.Text)},
If(
input >= 1 && input < 4,
"Low",
input >= 4 && input < 9,
"Intermediate",
input >= 9 && input < 15,
"High",
input >= 16,
"Very High",
"NA"
)
)

[WarrenBelz]

@mezcalbean ,

I need to ask you one question here - do you understand the structure of a Patch statement (that is what your latest post asked about)? If not, this is going to be difficult (and it is still not entirely clear to me exactly what you want to do here).

[mezcalbean]

Hi @WarrenBelz 

To answer your questions in regards top Patching yes I do but not completely hence the request for help.

Here is my patch statement which is working well - I am trying to patch a choice field, am I saying/asking it correctly?

That is I have one field giving me a sum. Chartext

Value(Label1_37+Label1_40+Label1_41+Label1_42+Label1_43+Label1_35+Label1_34+Label1_33+Label1_32)

Another field making reference to Chart text - Riskbox - to give me a level 

With( {input: Value(charttxt.Text)}, If( input >= 1 && input < 4, "Low", input >= 4 && input < 9, "Intermediate", input >= 9 && input < 15, "High", input >= 16, "Very High", "" ))

This is what I need to Patch to SharePoint. I can BUT with SharePoint when trying to filter the results it will give me a list that is one line per entry, I require only one that is low, inter high etc...

Now the question am I filtering it incorrectly or should I Patch it to a choice column within SharePoint.

Patch(
    AllSubmittedData,
    Defaults(AllSubmittedData),
    {
        
        field_1: If(
            Toggle1_1.Value,
            "Yes",
            "No"
        ),
        field_2: If(
            Toggle1_5.Value,
            "Yes",
            "No"
        ),
        field_3: If(
            Toggle1_4.Value,
            "Yes",
            "No"
        ),
        field_4: Radio2_1.Selected.Value,
        field_5: Radio1_2.Selected.Value,
        field_6: Value(TextInput1_6.Text),
        field_7: Value(TextInput1_7.Text),
        field_8: Value(TextInput1_11.Text),
        field_9: Value(TextInput1_10.Text),
        field_10: Value(TextInput1_9.Text),
        field_11: Value(TextInput1_8.Text),
        field_20: Value(Label1_37 + Label1_40 + Label1_41 + Label1_42 + Label1_43 + Label1_35 + Label1_34 + Label1_33 + Label1_32),
        field_21: Value(Label3_13.Text) * 100,
        field_22: Value(Label3_14.Text),
        field_23: Value(Label3_15.Text) * 100,
        Comorbidities: Radio1_3.Selected.Value,


field123: Text(txtG_1.Text),
        field_24: Text(txtfirstn.Text),
        field_25: Text(txtlastname.Text),
        field_27: Text(txtDOB.Text),
        PT_IDENTIFIER: Text(txt1_3.Text),
        Number: Text(lblmailnickname.Text),
        status: Toggle2.Value
        
    }
);

[WarrenBelz]

@mezcalbean ,

Back to your original question here - where is the Choice Filed you want to Patch to?

[mezcalbean]

Hi @WarrenBelz 

I am trying to patch the Rick box that is gives me a the list of 4 - I have set that up in t SP with those 4 choices

With( {input: Value(charttxt.Text)}, If( input >= 1 && input < 4, "Low", input >= 4 && input < 9, "Intermediate", input >= 9 && input < 15, "High", input >= 16, "Very High", "" ))

[WarrenBelz · Accepted solution]

@mezcalbean ,

Yes, but what is the name of the field and is it in the code you posted - I will assume not for the moment. Note the below relies on your posted code being correct - the choice field is at the bottom

Patch(
   AllSubmittedData,
   Defaults(AllSubmittedData),
   {
      field_1: 
      If(
         Toggle1_1.Value,
         "Yes",
         "No"
      ),
      field_2: 
      If(
         Toggle1_5.Value,
         "Yes",
         "No"
      ),
      field_3: 
      If(
         Toggle1_4.Value,
         "Yes",
         "No"
      ),
      field_4: Radio2_1.Selected.Value,
      field_5: Radio1_2.Selected.Value,
      field_6: Value(TextInput1_6.Text),
      field_7: Value(TextInput1_7.Text),
      field_8: Value(TextInput1_11.Text),
      field_9: Value(TextInput1_10.Text),
      field_10: Value(TextInput1_9.Text),
      field_11: Value(TextInput1_8.Text),
      field_20: Value(Label1_37 + Label1_40 + Label1_41 + Label1_42 + Label1_43 + Label1_35 + Label1_34 + Label1_33 + Label1_32),
      field_21: Value(Label3_13.Text) * 100,
      field_22: Value(Label3_14.Text),
      field_23: Value(Label3_15.Text) * 100,
      Comorbidities: Radio1_3.Selected.Value,
      field123: Text(txtG_1.Text),
      field_24: Text(txtfirstn.Text),
      field_25: Text(txtlastname.Text),
      field_27: Text(txtDOB.Text),
      PT_IDENTIFIER: Text(txt1_3.Text),
      Number: Text(lblmailnickname.Text),
      status: Toggle2.Value,
      YourChoiceField:
      With(
         {
            wChoice:
            With(
            {input: Value(charttxt.Text)},
            If(
               input >= 1 && input < 4,
               "Low",
               input >= 4 && input < 9,
               "Intermediate",
               input >= 9 && input < 15,
               "High",
               input >= 16,
               "Very High",
               "NA"
            )
         ),
         {Value: wChoice}
      )
   }
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[mezcalbean]

Hi @WarrenBelz I have added an example Power App with a simple input value to a text field to help me understand what is going on. I have also added the a photo of the share point choices - hopefully we can work this out. I have also added @zmansuri as he was originally the one who help out with some of the code.

[WarrenBelz]

Hi @mezcalbean ,

Firstly, the app is no good to me without the data source, but I honestly do not have the time to debug an app.  However the code I posted last should Patch one of those values to a Choice field - are you getting any errors on it?

[mezcalbean]

Thanks @WarrenBelz it wasn't for you to debug the app purely as an example of simple demonstration of what I am trying to accomplish/explain/show.  

[WarrenBelz]

@mezcalbean ,

I actually opened the app now and noted it has no data - your code however is not what I posted - you have this on the label

With(
   {input: Value(charttxt.Text)}, 
   If(
      input >= 1 && input =3, 
      "Low", 
      input >= 4 && input < 9, 
      "Intermediate", 
      input >= 9 && input <=15, 
      "High", 
      input >= 16, 
      "Very High", 
      ""
   )
)

You have the wrong logic in a couple

With(
   {input: Value(charttxt.Text)}, 
   If(
      input >= 1 && input < 4, 
      "Low", 
      input >= 4 && input < 9, 
      "Intermediate", 
      input >= 9 && input < 16, 
      "High", 
      input >= 16, 
      "Very High", 
      ""
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[mezcalbean]

Thank you for your help - I go there in two parts one with your code and then  using  distinct on the filter