Help for compare excel and list sharepoint (Power automate)

Question

Hello saviors,

In my excel table, I have a product column (agricultural products) that I would like to compare to a column in my sharepoint list that only contains cereals.

If a row in my Product column in excel contains a cereal, my condition is true. If it's not a cereal, then it's false. I have 73 items in my sharepoint list and 13 in my product column.

I already use “filter array” and the “Contain” function to filter and compare my columns but it doesn't work. I've used loops and that doesn't work either. I'd just like to see if anyone has already compared a column in their excel file to their sharepoint list? maybe my workflow is misspelled

This is the last flow that I am trying. (screen shot)

Thanks in advance.

Abdoul Hakim YONDOU · Answer

Thank you very much for your reply. In fact I had tried a loop nested in a loop where each row of my excel table runs through my entire sharepoint list but it is very time consuming and not opitmisant since my sharepoint list contains 73 rows. maybe i'm the one who didn't build my flow properly i'm providing you with a screenshot of my excel table and my list

Eliana Blake · Answer

Hey there! I understand your challenge in comparing the product column in your Excel file with the cereals column in your SharePoint list using Power Automate. It seems like you've already tried using the "filter array" and "Contain" function without success. One approach you could consider is to loop through each item in your Excel product column and check if it exists in the SharePoint cereals list. Here's a high-level overview of a possible solution: 1. Use the "Get items" action to retrieve all items from your SharePoint cereals list. 2. Initialize an empty array variable to store the matches found between Excel and SharePoint. 3. Loop through each item in your Excel product column using an "Apply to each" action. 4. Within the loop, add a condition to check if the current item is a cereal (you can define a list of cereals for comparison). 5. Inside the condition, use another loop to compare the current Excel product with each item in the SharePoint cereals list. 6. If a match is found, add the product to the array variable. 7. Finally, you can use the array variable to display or process the matching products. It's essential to ensure that the data types and comparison methods are consistent to achieve accurate results. If you encounter any specific errors or challenges in your Power Automate workflow, feel free to share more details for further assistance. Don't hesitate to ask if you need more guidance or specific examples tailored to your scenario. Good luck with your comparison task!