Unanswered

List rows present in table followed by condition not working

(0) Share

Report

Posted on by Pajeffery

I have a very simple flow setup that I'm struggling with, I'm using the list rows in Excel to pull all data from a spreadsheet, I'm then using one of the values from the spreadsheet (The value is either Yes/No) to input into a condition.

The challenge I have is that the value from the spreadsheet is coming back as null and therefore the condition won't work. I've checked the output from the list rows and the data has been retrieved. Also there are other fields in the row that are being retrieved it just seems to be the Yes/No fields.

Is there an obvious reason why this might be the case?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Hi @Pajeffery

Can you see the yes/no in the history output for list rows? How did you construct the dynamic value? Have you tried inserting the two dynamic values of the condition into a compose/select to see what is the output? Can you share what you are seeing?

I built the following:

From a table :

This has worked out OK for me.

Conditions on strings are case sensitive - could that be your issue?

Damien

Was this reply helpful? Yes No
Pajeffery 11 on at

Like (0)

Report

Hi Damien, thanks for responding, I'll try and get a screenshot from my work laptop asap.

I can see the output from Excel and the values are present.

The approach is almost identical to yours, except I don't have a select step - Do you think this is required?

I've added the dynamic values into a compose and the other columns appear, its just the one column that I need that isn't showing.

I didn't know about the case sensitive bit, but as they are appearing as null I don't think that is an issue.

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Hi @Pajeffery

The select was just there as a check. Null is returned if using ? in an expression for a json object and it doesn’t exist, so if you’ve built your own expression, there might be a typo.

Did you select the dynamic value for this column or type your own expression?

Damien

Was this reply helpful? Yes No
Pajeffery 11 on at

Like (0)

Report

I definitely selected the dynamic value, the spreadsheet is generated by an MS Form and the column headings are very long so definitely wouldn't be typing them.

There is a question mark though, I'm guessing that is added by default when you select the dynamic value.

Was this reply helpful? Yes No