Answered

Dependence of parameters on each other

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

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

Like (0)

Report
Copy link

Link copied!
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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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