Get optional responses

(0) Share

Report

Posted on by Community Power Pla...

I have setup a MS Form that users need to fill out to submit a list of authors, I need to be able to set a variable that populates a field that gathers those together or ignores them if no data entered, can anyone help?

The form is set so you can select from 1 to 6 authors, the flow then collects that data together.

So ideally the flow should then be able to say "ok so we have 3 authors, then I'll fill out Author Surname 1, Author Forename 1, Author Surname 2, Author Forename 2, Author Surname 3, Author Forename 3" and set as a variable.

Completely ignoring any requests for author forename 4+ and any formating in the variable box that does'nt match

All responses (1)

Answers (1)

Verified answer

v-litu-msft on at

Like (0)

Report

Re: Get optional responses

Hi @Anonymous,

You can initialize a String variable named Message, and change the Authors variable into an Array variable.

Get the response, and create an object array as below, put the array into the Authors array:

Create an Apply to each action, then add the expression length(item()?['Author Surname']) into the condition, if the length of Author Surname is equal to 0, Append the Message string variable as below:

Run result:

Please have a try, it will help you.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.