I have an HTML with people. Im storing the people in a collection called Balance under EmployeeName.
In sharepoint i have a list called HR with all the people and a yes/no column. If the column is set to yes i want to display "Card" next to Employee name.
i've tried
If( true in HR.OData__x0037_Card And EmployeeName in HR.Title, ", Card")
but this will display "Card" for everybody, even for those who have have no in sharepoint list
Solved! Go to Solution.
I've managed to solve it.
If( EmployeeName in Filter(HR, OData__x0037_Card=1).Title , ", Card")
instead of searching for true, false, yes or no i switched to 1 and 0. This gives me what i want.
Still puzzled about the if issues. I tried
If( "***" in HR.OData__x0037_Card , ", Card")
and returns true
just tried
If( "z" in HR.OData__x0037_Card , ", Card", "NOTHING")
and this returns true and displays "Card".
I dont know how it can be possible for "z" to exist in "yes/no" or "true/false"
@Konjic Hi
Think your trouble might be connected with the YES/NO column this type is not working well in the PowerApps.
Please for the testing add the Text type filed where you would add in manually values "Yes" , "No"
Refresh Data source and add new column to Power App.
Apply formula:
If( "Yes" in HR.OData__x0037_Card And EmployeeName in HR.Title, ", Card")
Test if this will resolve your problem if yes, please accept this answer as solution.
If no, please share more details about your use case:
- HTML with people ?
- Are you displaying / building dynamic content using Collection and HTML ?
Did that and didnt solved the problem.
What i mean by "HTML with people" is i have an HTML table filled with text values stored in a collection
Yes. Im building a dynamic HTML table using multiple collections
I've managed to solve it.
If( EmployeeName in Filter(HR, OData__x0037_Card=1).Title , ", Card")
instead of searching for true, false, yes or no i switched to 1 and 0. This gives me what i want.
Still puzzled about the if issues. I tried
If( "***" in HR.OData__x0037_Card , ", Card")
and returns true
User | Count |
---|---|
179 | |
118 | |
87 | |
44 | |
41 |
User | Count |
---|---|
241 | |
153 | |
127 | |
77 | |
72 |