Is there any way to validate Excel Header Order with SharePoint List Column order?

(0) Share

Report

Posted on by PratikD21

Hi,

We have requirement that provided excel header order should be validated with SharePoint List column order?

Is there any way to perform this validation?

Thanks.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Community Power Pla... on at

Like (0)

Report

What do you mean by order? You mean 1st 2nd 3rd column not by names or what you try to achieve.

Was this reply helpful? Yes No
PratikD21 38 on at

Like (0)

Report

Hi,

I have SP List whose column order is like TItle, Data1, Data2, and Excel table which has order like Title, Data1, Data2.

I want to validate this order then only it should proceed with other actions like data insert/update/delete in SP List.

Thanks.

Was this reply helpful? Yes No
PratikD21 38 on at

Like (0)

Report

Hi, I have SP List whose column order is like TItle, Data1, Data2, and Excel table which has order like Title, Data1, Data2.

I want to validate this order (Comparison of SP List Column Order and Excel Data Header Order) then only it should proceed with other actions like data insert/update/delete in SP List.

Thanks.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

What do you mean to validate? You have to describe the condition or whatever. Step by step. I need to know the details.

For example:

1. I want to match title columns at files

2. Check the data: if column A,C,F are not the same:

2.a add to new sp list

2.b delete the record

or whatever is the description. Please describe this like that.

Was this reply helpful? Yes No
PratikD21 38 on at

Like (0)

Report

Hi @Anonymous ,

I have a SharePoint list that has columns Title, Data1, Data2, and Excel File which has column header as Title, Data1, Data2.

I want to match the order of the SP List Column and Excel Header Column. If orders match successfully, I will proceed with importing the excel data to SP List.

Example,
1. SP List Order - Title, Data1, Data2
Excel Column Header Order - Title, Data1, Data2
Outcome/Result - Validation Successful

2. SP List Order - Title, Data2, Data1
Excel Column Header Order - Title, Data1, Data2
Outcome/Result - Validation Failed

3. SP List Order - Data2, Data1, Title
Excel Column Header Order - Data1, Title, Data2
Outcome/Result - Validation Failed

Please let me know if any other details required.

Thanks.

Was this reply helpful? Yes No