Forum Discussion

CG_Chris's avatar
CG_Chris
New Member
3 years ago
Solved

Form to list formula query (An easy one)

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.