web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Compare 2 tables with ...
Power Automate
Unanswered

Compare 2 tables with different formats (one row based, the other column based)

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi everyone,

Need help and guidance pls...

 

I have 2 tables at hand and I want to update the values in Table 2 based on values of Table 1 but unfortunately they use different format. Table 1 is managed in one row with a long columns, while details in Table 2 is managed in different rows.

 

Table 1 is as follows where the number of trainers for various batch

biTiqa_0-1687884710452.png

 

I want to use the numbers from Table1 to update Table 2 with the following format

biTiqa_1-1687884710318.png

 

I want to run a flow so the numbers in Table 1 can be stored to Table 2.

 

Appreciate your guidance on how I can achieve this pls...

 

Thanks alot!

biTiqa

Categories:
I have the same question (0)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 283

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard