cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Larry_Casey
Helper II
Helper II

Update Table based on values in another

Hello,

 

How could I build an automation that reads data from One SQL table (Currency) and then updates a second SQL table that matches the currency code in the first table.

 

The first table would have columns for Currency ID and then Amount and the second table would have Currency ID and Amount.

 

I want to update the amount in table 2 with the amount in table 1 that matches currency ID.

 

2021-04-09_130421.png

2 REPLIES 2
Larry_Casey
Helper II
Helper II

2021-04-09_130421.png

PatrickMSFT
Microsoft
Microsoft

Larry_Casey,

 

It looks like you've got a good start. Mostly, you just want to pull in data from your data sources and use variables to better codify that data. You can then use the variables in Condition branches, create tables, whatever else. We have a Select action that can match up key/value, as well.

 

This isn't spot on to your scenario but it has a lot of relevant guidance:
https://ryanmaclean365.com/2020/01/29/power-automate-html-table-styling/

 

I hope this helps!

 

Patrick

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (74,796)