Skip to main content
Community site session details

Community site session details

Session Id : gvztO7xBkbhDvWvfFN3PsS
Power Automate - Building Flows
Unanswered

Initialize multiple variables at the same time, assign each one a form answer, and tidy up all the variables (toupper, trim, replace special characters, etc.)

Like (0) ShareShare
ReportReport
Posted on 26 Mar 2024 08:21:58 by 61

Hi!

 

I'm trying to be better at making simple clean flows. So far I have used form answers in a case by case basis, tidying up here and there and using them in e-mails with formatted HTML tables. But now I need to actually start storing a lot of information as SharePoint list items to later use in PowerApps.

 

Is there a better, cleaner, simpler way to do the following?

 

  • Capture the answers from a form.
  • Initialize multiple variables in one step, one variable for each answer.
  • Assign an answer to each variable.
  • Run all variables through a step to make them uppercase, trim leading a trailing spaces, convert special characters (Á, È, Ü) to regular (A, E, U), and so on.

 

I'm following some tutorials and I have initialized an 'object' type variable and declared the value as:

 

{

"var1": [form answer dynamic content]

}

 

But it occurred to me that I don't want to format each line with multiple "replace(replace(replace". Also, I don't want to use the form answers "as is" because in the past I've had problems with random spaces that I could not remove until I've stored the answer as a variable.

 

Do I need to store all the variables in an array to run them through a "cleaner"? Can I initialize an array variable insted of an object one?

 

Any help or different approeach is appreciated. Thank you.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete