Dependence of parameters on each other

[LukaszM]

Hi
My data source is the SP list which contains many parameters.
I want to write a formula that depends on whether the "Nr pierscienia." parameter has a completed parameter, e.g. "NrC"
I would like to receive the value "true" if the parameter named "Nr pierscienia" contains the parameter "NrC" and if it does not contain "false"
Is it possible to write such a condition?

Best regards

[EricLott]

When you say ""Nr pierscienia." parameter" do you mean a column named "Nr pierscienia."?

In other words, you have a SP list and you want to receive a true/false based on whether or not the column "Nr pierscienia." says "NrC"?

If so, in SharePoint you can create a calculated column in the list. See my attachment. You can use a formula that returns true/false 
based on whatever you need and then use that column in PowerApps.

Here are formula examples: https://support.office.com/en-us/article/examples-of-common-formulas-in-sharepoint-lists-d81f5f21-2b...

[v-xida-msft]

Hi @LukaszM ,

Do you want to check if the "Nr pierscienia" column (in your SP List) contains the specific "NrC" value?

I assume that you add a Gallery control in your app to list all available records from your SP list, is it true?

Please consider add a Label within above Gallery, set the Text property to following:

If(
    "NrC" in 'Nr pierscienia',
    "true",
    "false"
)

Please take a try with above solution, check if the issue is solved.

Best regards,

[LukaszM]

Hi v-xida-msft

Yes, I have galleries in my application. I wrote it wrong earlier, sorry.
I want to enter a value in "Nr pierscienia" and I would like to receive a value for "NrC" if the given "Nr pierscienia" has it and if it does not display anything.

Example:
1. In the sharepoint list I have a "Nr pierscienia" with a value of 22, I would like me to display the values for "NrC" up to "NrA"
2. However, if I enter in the "Nr pierscienia" a value of e.g. 30, which I do not have in the SP list, I want to have an empty field
Is it possible to do this?

At this moment he reads me the last value from the SP list.

In attachment :
- main view

Best regards

[v-xida-msft · Accepted solution]

Hi @LukaszM ,

Do you list the "NrC" up to "NrA" using a Gallery?

Do you want to display the values for the "NrC" up to "NrA" in your Gallery based on the entered "Nr pierscienia" value?

Based on the needs that you mentioned, I think the If function could achieve your needs. Please consider take a try with the following workaround:

Within the Gallery, set the Default property of the Segment TextInput box to following:

If(
   NrpierscieniaTextBox.Text in 'YourSPList'.'Nr pierscienia',
   ThisItem.ColumnName,
   Blank()
)

If you do not use a Gallery control to list the "NrC" up to "NrA", please consider set the Default property of each Segment TextInput box to following:

If(
   NrpierscieniaTextBox.Text in 'YourSPList'.'Nr pierscienia',
   ThisItem.'NrC',
   Blank()
)

If(
   NrpierscieniaTextBox.Text in 'YourSPList'.'Nr pierscienia',
   ThisItem.'NrE',
   Blank()
)

If(
   NrpierscieniaTextBox.Text in 'YourSPList'.'Nr pierscienia',
   ThisItem.'NrD',
   Blank()
)

...

...

Best regards,

[LukaszM]

Hi  v-xida-msft,
I  am using Gallery and I chose first proposition.
Thank you for your solution.

Best regards 
Łukasz