Hello,
I have a Flow that Gets Items from a SharePoint List and then Selects the items so that it can be placed into a CSV table.
I receive the same type of error when there are blank and null fields within the Select Card, for example this kind of error:
…failed: 'The template language expression 'item()['TestDate']' cannot be evaluated because property 'TestDate' doesn't exist, available properties are '…
I have successfully addressed all of the fields except for Choice Fields. Does anyone know the proper syntax for choice fields missing a value?
This is my Flow:
Flow
Select
Expressions
The expressions I have tried for the choice field are:
if(equals(coalesce(item()?['Development_x0020_Team_x0020_1']['Value'],'NULL'),'NULL'),'',coalesce(item()?['Development_x0020_Team_x0020_1']['Value']))
If(equals(length(item()?['Development_x0020_Team_x0020_1']['Value']), 1), item()?['Development_x0020_Team_x0020_1']['Value'], '')
Thank you,
Joanna