Form to list formula query (An easy one)

[CG_Chris]

I am sure this is really easy but I am new to Power Apps.

I have created a form which accepts multiple answers and a Microsoft list with the columns split out for each variant of the answer. At the moment each column is populated by the flow with "True" or "False" depending on whether the answer has been selected on the form. I want it to only populate if the answer has been selected and stay blank if it hasnt.

The formula i have used is;

if(contains(outputs('Get_response_details')?['body/r98e064XXXXXXXXXXfbd9463c6709201'],'Employee'),true,false)

Is there a better way of doing this? I have tried removing "false" and replacing with "0" but this doesnt work.

[v-jingzhang · Accepted solution]

Hi @CG_Chris 

This community is for Power Query. To seek for suggestions regarding to building PowerApps, you can go to Building Power Apps - Power Platform Community. Hope this helps. 

Best Regards,
Community Support Team _ Jing