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

Notifications

Announcements

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

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 375 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 269 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 127 Most Valuable Professional

Last 30 days Overall leaderboard