Updating or adding a new row in Excel

(1) Share

Report

Posted on by JG-04102324-0

I have a sharepoint list that employee are using. I would like to extract to an Excel in order to create stats/pivot tables. The problem with my flow is that every time it runs, the condition is always false even when the ID from sharepoint is already listed in the Excel. It adds a lot of duplicate lines as a results. Am I missing something ?

The collunm names are:

Excel: GCSX

SharePoint: GCSXRequestNumber

The 'from' field in the filter array action is : outputs('List_rows_present_in_a_table')?['body/value']

Categories:

Business Process Flows

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Michael E. Gernaey 48,863 Super User 2025 Season 2 on at

Like (1)

Report

Updating or adding a new row in Excel

Hi

I don't quite think you are doing what you mean to do, or we need to fix what you have.

Ok so you are doing a list rows from Excel, based on some filter I cannot see. But I don't quite understand that because you then try to filter it, by another value.

Is this because the value you use in the Filter array action, is NOT the Key of the row? And if not, why not if thats what you need to filter by? This way your initial List Rows would simply pull back 1 row pr 0.

Either way...

1) Is the item data type a String or Number for GCSX (I thinks its an X its so small I cant read it well)

and then is your incoming a Number which you then use a string expression to convert?

2) how did you build your expression? I am concerned that it sees it as Text, and not actual expressions and hence it would fail each time

Can you go to the Flow Run itself.

A) Go to the Output of the List Rows, let's makes sure it has Rows and look at the Raw Output, so you can see what values are there and if they match the current GCSX Variable

B) Go to the Raw Input of the Filter Array, let's grab that data so we can see exactly what you are pulling

C) At the same time, let's grab the value of the GCSX variable

D) Let's make sure they are strings, let's make sure that there are no Spaces in the front or end of your converted (string) value

You may need to add a trim around your string(values) because if there are spaces it will make it not be equal.

One of these will answer your question as to why they aren't working

Was this reply helpful? Yes No