Empty field will not return rows exporting from Planner to Excel

[opc10]

Hi all,

im having an issue where i'm extracting the tasks from a planner board and it will only populate the excel table if all the fields have a value. eg:

I extract Task Title, Assignee, Due Date.

In the 'Add row to a Table' action If the Due date is blank on a Task then it will not retrieve the row.

I basically want all rows and if a field value is blank then just return a blank.

Thanks in advance

[v-bofeng-msft]

Hi @opc10 :

I've made a  test but did not encountered the problem you mentioned.

Even if I pass a null value, I can insert a row.

If this problem cannot be solved, I suggest you try this solution:

Best Regards,

Bof

[opc10]

Thanks for the reply.

I could do that but theres a bunch of fields so will make for a bit of a messy flow.

Also I'm not entirely sure passing a null value via the flow is the same as actually extracting it from planner? Although i could be wrong.  

Be interested to see the results using planner if anyone is not having the issue. I'm suspecting it may be the way i've constructed the flow?

So here i'm getting a list of all planner boards for any teams i belong to and then gathering the fields i want. After this step is the standard populate the excel file with the values/outputs.

[v-bofeng-msft · Accepted solution]

Hi @opc10

Has your problem been solved?
what can I do for you?

If you don't want to use the condition action, maybe you can try this solution:

Reference Expression:

if(equals(outputs('Compose'),null),null,outputs('Compose'))

Best Regards,

Bof