Unanswered

Compare Excel table Header data to Share Point List

(0) Share

Report

Posted on by Community Power Pla...

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 1

Figure 2

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-jefferni on at

Like (0)

Report

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:

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,

Was this reply helpful? Yes No
Deepa2 38 on at

Like (0)

Report

Re: Compare Excel table Header data to Share Point List

can someone explain the flow in detail

Was this reply helpful? Yes No