cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LukaszM
Helper I
Helper I

Dependence of parameters on each other

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

1 ACCEPTED SOLUTION

Accepted Solutions

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
EricLott
Super User
Super User

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
Community Support
Community Support

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi

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

 

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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

Best regards 
Łukasz

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (62,757)