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]

Hi @mezcalbean ,

You would filter the List using that

With(
   {
      wRating:
      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"
         )
      )
   },
   Filter(
      SPList,
      Risk = wRating
   )
)

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

[WarrenBelz]

Hi @mezcalbean ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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]

Apologies @WarrenBelz I did write a reply - must of been discarded and not sent, no I have not got this working.

I have one page where I am collecting the data, the field and listing it in SharePoint with no issue. When I try and filter it on another page I get the list of every choice entered not the 4 what I am after. I could either be doing the filter incorrectly or the input is incorrect? I have added a picture for example.

Also I was unsure what you meant with what is this doing ?

wRating

Regards

[WarrenBelz]

Hi @mezcalbean ,

You can call that whatever you want - I just use that structure. Can you please post the exact code you have used (in Text), what is is returning and what it is you expect.

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 

using 

With(
   {
      wRating:
      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"
         )
      )
   },
   Filter(
      SPList,
      Risk = wRating
   )
)

 gives me the result of the different levels - that is inputted into SP . in SP I have a list of then many entries of each level with each record. 

On the next page I have drop down linking to that dropdown - I want to be able to choose or filter on 4 records as when I link it which gives me the image attached before (list.png) - does this make sense apologies if not?

Regards

[WarrenBelz]

Hi @mezcalbean ,

Sorry, I a little confused - you want to filter the list according to the input of a text box and the code is doing this. You posted a graph as an example - how is that relevant ?

[mezcalbean]

Hi @WarrenBelz 

I think what I am asking advice on please is to patch a choice field with this  code

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"
)
)

 Thanks 

[WarrenBelz]

Hi @mezcalbean ,

Is this inside an existing Patch (you are only specifying this field and the resulting content required)

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"
            )
         )
      )
   },
   Patch(
   YourSPList,
    . . . CriteriaHere . . .,
   {
      Field1: . . . . 
      Field2: . . . .
      YourChoiceField: {Value:wChoice}
      Field4: . . . . . 
   }
)
      

You can actually put the top statement inside the Patch, but I think this is cleaner.

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 apologies its me and thank you for your time.

I add this to the field

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"
            )
         )
      )
   },

and in the patch statement

Patch(
   YourSPList,
    . . . CriteriaHere . . .,
   {
      Field1: . . . . 
      Field2: . . . .
      YourChoiceField: {Value:wChoice}
      Field4: . . . . . 
   }
)

Sorry I am a bit lost - rereading what i said - I use a patch to submit the text box's but unsure with the choice

Thankyou