cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Konjic Helper III
Helper III

Display message in HTML table based on YES/NO SharePoint List

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Konjic Helper III
Helper III

Re: Display message in HTML table based on YES/NO SharePoint List

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 

View solution in original post

4 REPLIES 4
Konjic Helper III
Helper III

Re: Display message in HTML table based on YES/NO SharePoint List

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"

365CornerDawid Resolver I
Resolver I

Re: Display message in HTML table based on YES/NO SharePoint List

@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 ?

 

Highlighted
Konjic Helper III
Helper III

Re: Display message in HTML table based on YES/NO SharePoint List

@365CornerDawid 

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

Konjic Helper III
Helper III

Re: Display message in HTML table based on YES/NO SharePoint List

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 

View solution in original post

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Attending MBAS? Claim your badge

Attending MBAS? Claim your badge

Whether you’re streaming the digital event live, or watching on-demand, claim your attendee badge to sport on your profile.

‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We're launching a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Emergency Response & Monitoring Solution

Emergency Response & Monitoring Solution

Microsoft has created a regional government emergency response and monitoring solution that is built on Power Apps and Power BI.

Top Solution Authors
Top Kudoed Authors
Users online (5,301)