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
Solved! Go to 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,
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...
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,
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.
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,
Hi v-xida-msft,
I am using Gallery and I chose first proposition.
Thank you for your solution.
Best regards
Łukasz
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
268 | |
225 | |
76 | |
38 | |
38 |
User | Count |
---|---|
339 | |
224 | |
121 | |
71 | |
57 |