You’re offline. This is a read only version of the page.
8
Hello,
I am currently working on automating a report we use at my company in order to accelerate procecess using an MS Forms to gather necessary info to populate a Word Document Template.
The report has a fixed format and cannot be changed. Part of the format includes the answer to some questions being checkboxes.
I have developed a simple solution that verifies the questions' answer and change the checkbox in the template accordingly as shown below:
(If answer = Yes then fill the associated content control with a Checked checkbox AND the 'NO' control with a blank one. If not do the opposite.)
My problem is that the report is long and some of the conditions are 3-answer, so it implies more nested actions and I am reaching Flow's limits.
Hence the question: can I write this whole action as an expression? So I can avoid using actions and then fill the content control using an expression.
TLDR: I need to know if I can transform the following action into an expression:
If answer = yes then set variable X into Y AND set variable W into Z, else, set variable X into Z AND set variable W into Y.
Thanks in advance,
Giulianno
Hi @iorigiu ,
You could set the variable's variable to
Share
Report
All responses (
Answers (
if(equals(FormFieldValue,'Sim'),'A','B')
directly instead of using the condition action.
Best Regards,
Bof
