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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Compare Excel table He...
Power Automate
Unanswered

Compare Excel table Header data to Share Point List

(0) ShareShare
ReportReport
Posted on by

Hi 

 

I have a Power automate flow(Automated cloud flow) that will create a Share point list when a excel file is uploaded in the Share point document library.

 

Requirement

1. I want to compare the table header values(Refer Figure 1) of the uploaded file with the Share point list column header data(Refer Figure 2).

2. If the compared values are same, I want to continue in creating the SP list.

3. If the values are different, i want to stop the flow and send a error/failed message through email.

 

I don't know which connector to use for checking these values. Can I have a detailed Solution.

Thank you

 

 

Figure 1Figure 1

Figure 1

 

 

Figure 2Figure 2

Figure 2

Categories:
I have the same question (0)
  • Verified answer
    v-jefferni Profile Picture
    on at
    Re: Compare Excel table Header data to Share Point List

    Hi @Anonymous ,

     

    Please refer to the solution in below thread:

    Solved: Is there any way to get the column headers from Ex... - Power Platform Community (microsoft.com)

     

    For comparison, I made a sample for your reference:

    vjefferni_0-1663748849730.png

    vjefferni_1-1663748916992.png

    vjefferni_2-1663748968387.png

     

    In the end, you can use another condition to check the number and see if it equals to the number of your columns.

     

    Best regards,

     

  • Deepa2 Profile Picture
    38 on at
    Re: Compare Excel table Header data to Share Point List

    can someone explain the flow in detail

     

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…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard