Apr 27 2018 08:05 AM - edited Apr 27 2018 08:07 AM
I am trying to build a flow connected to a SharePoint list with a few person fields. However if I try to access any of the person fields and they are blank, it chokes. I even get an error if I try to test the field for null or empty. I'm not sure how to proceed. These are not required fields.
The error I get is something along the lines of:
The template language expression 'triggerBody()?['PersonField']['DisplayName']' cannot be evaluated because property 'DisplayName' cannot be selected.
Doesn't seem to matter which field I'm trying to get: Claims, DisplayName, Email, etc
Apr 27 2018 08:27 AM
I would look at setting variables as shown here:
https://veenstra.me.uk/2018/04/20/microsoft-flow-getting-your-sharepoint-field-values/
You will need to use conditions to then check the value of the people fields before doing anything with them.
Apr 27 2018 09:28 AM - edited Apr 27 2018 09:28 AM
Thanks for the quick answer.This helped me clarify things a little. In case it helps anyone else, here's what I had to do.
Initialize variables for each field (no value).
Try a condition against each person field, testing the Object field itself (not Claims, DisplayName, etc) for null.
Then if it wasn't null, I could assign the right value to the variable.
I think my problem was that I was testing my conditionals against a value in the object, not the object itself.
Thanks again.