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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

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

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (3,726)