Hi @Anonymous,
Could you please share a screenshot of your flow's configuration?
Could you please show a bit more about the Form that you mentioned?
Further, could you please show a bit more about the toggle columns that you mentioned? Is it the Yes/No type column in SharePoint?
I suppose that the toggle column that you mentioned is the Yes/No type column in SharePoint. Yes, you are right. the output (value) of Yes/No type column in SharePoint would be decorated as true/false within Microsoft Flow. If you want to return Yes in your email when the Yes/No type column value decorated as true within Microsoft Flow, I think the if() expression could achieve your needs.
I have created a SharePoint list on my side and the data structure of it as below:
Note: The Is Student column, the Is In Service column and the Is Flow Staff column are all Yes/No type column in my SharePoint list.
I have made a test on my side and please take a try with the following workaround:
- Add a "When an item is created" trigger, specify Site Address and List Name.
- Add a "Send an email" action, specify To field. Within Body field, there are three if() expressions. The first if() expression read as below:
if(equals(triggerBody()?['Is_x0020_Student'],true),'Yes','No')
The second if() expression read as below:
if(equals(triggerBody()?['Is_x0020_In_x0020_Service'],true),'Yes','No')
The third if() expression read as below:
if(equals(triggerBody()?['Is_x0020_Flow_x0020_Staff'],true),'Yes','No')
Note: On your side, you should type the following formula within Body field of "Send an email" action of your flow:
if(equals(triggerBody()?['ToggleColumnNameofyourSharePointlist'],true),'Yes','No')
If there is a space within your toggle column name, please replace the space with '_x0020_' within above formula.
Image reference:
The flow works successfully as below:
More details about using expressions within flow actions, please check the following article:
Use expression within flow actions
Best regards,
Kris
