cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tim-Holmes73
Regular Visitor

Expression assistance

I am using forms and powerautomate to create a CSV for me, that is emailed over to the IT dept then we use that to make accounts.

One of the form drop downs is location, when they choose that, I would like an expression that can populate the whole of the address for our company, either site a or b.

So, if they choose Vancouver as the location, I would like it to write our full postal address etc, if they choose Victoria, I would like to write the full postal address for that office.

How can I go about doing this please?

Thanks in advance.

2 REPLIES 2
eric-cheng
Solution Sage
Solution Sage

Hi @Tim-Holmes73 ,

 

Here are a few options:

 

1) If you have the mapping between location and the address in a SharePoint list, Excel or SQL table, your flow can query the data source and pass in the location as a filter.  

 

2) Pass the location to a switch statement and update a variable with the address.  This will be hardcoded though and cumbersome for large amount of locations.

 

Not sure if an expression would mke sense as it can get complex very quickly with more than a couple locations.  It will also be a pain if you need to add/remove locations in the future.

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

 

 

Hi Eric

I believe the second option would be the best, we have 2 locations and that is it.

Could you give some guidance or an information resource please so I can have a look.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (1,443)