You’re offline. This is a read only version of the page.
Announcements
4
I am just getting into PA and have searched quite extensively for this, but have not found an answer. I have an MS Forms questionnaire for our managers that has Yes/No questions with branching for things like, "Is the employees title changing?". If they answer Yes, it takes them to the questions "What is the new title?" and "What is their current title?". If they answer No, it takes them just to the question "What is their current title?". There are about 10 questions that are similar. At the end of the questionnaire I have a PA flow setup to insert the answers via Dynamic Content on a Word document template, then save that Word document. All pieces work just fine, except I am unsure how to setup the flow so that the information in the Dynamic Content is correct. In the example above I would need the Dynamic Content to filter based on an expression, something like "if 'new title' is NULL then output 'current title'". Any help with figuring this out, would be much appreciated. Thanks!
Hi there,
You can use IF statements in your expressions to achieve what you're looking for - almost exactly as you worded it, too! Use the expression tab, and your formula will look something like this:
Basically: if(empty('new title'),('current title'),('new title'))
For example, in my scenario below, if the field (that long ID) is empty, I want it to write 'Empty' into the field; if it's populated, I want it to write in whatever the user typed in.
Cheers,
Rhia
Share
Report
All responses (
Answers (
