Unanswered

Dependence of parameters on each other

(0) Share

Report

Posted on by Community Power Pla...

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

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Community Power Pla... on at

Like (0)

Report

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-2b4e-45ce-b170-bf7ebf6988b3

spExample.png

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report
Hi @Anonymous ,

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,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Screen1.png

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (0)

Report
Hi @Anonymous ,

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,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Best regards
Łukasz

Was this reply helpful? Yes No