compare Item from Excel with item from Sharepoint List

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I want to compare an item from a sharepoint list with an item from excel file.

Somehow the column name from Shrepoint List is not displayed .

Does anyone know what could be the reason for this!

Thanks in advance

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Cayshin 314 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

Can you please explain more and/or share a screenshot of what you mean by "the column name form SharePoint List is not displayed"? I'm assuming you mean it's not displaying in the Dynamic content list?

I'm going to take a random stab since we'd need more information, but one reason could be that wherever you are trying to insert that "column name" dynamic content is expecting a data type that is different from the one you set the "column name". In that instance, the Dynamic content will only show you compatible columns. I.E. If it's expecting a Number/Integer, then it won't show you text or date columns.

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

Like (0)

Report
Copy link

Link copied!

Thanks for the feedback.
There is an excel list which is populated by different users.
The details in excel list then need to transfer automatically in a sharepoint list.
If there is completely new data, then the whole row is re-added in Sharepoint List.
If the data already exists in Sharepoint List?
then the data will only be updated
To determine this, then the serial number of a row in Sharepoint List must be compared with the serial number of an Excel list.
But this does not work and I get an error, so that column "Serial number" is not present in Sharepoint list, although the column does exist.
I would like to compare "Seriennummer" in Sharepoint list with "Seriennummer" in Excel.

Was this reply helpful? Yes No