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
Solved! Go to Solution.
Hi @MD7648,
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.
Hi @MD7648,
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.
User | Count |
---|---|
88 | |
40 | |
23 | |
20 | |
16 |
User | Count |
---|---|
130 | |
50 | |
48 | |
35 | |
26 |