I am working on an app to automate adding/updating users contact information in MS 365 (with the Graph API).
Unfortunatly I encountered an issue to which I cannot think of a proper solution:
Since not all contact data (jobtitle,department,phonenumbers etc) need to be updated everytime, the fields in both the app and the PowerApps V2 trigger are optional.
The problem is that if a field is not populated it does not pass it on to the next steps, it just gets rid of it. No Empty field, no Null, no Blank just poof its gone. In the screenshot below you can see, there are 10 input fields, if only 5 are filled (or any other number) it does not pass on the other empty fields in the output:
As a result the HTTP step with the Graph API fails because there is no input, the exact error it gives is:
Unable to process template language expressions in action 'textNullCheck' inputs at line '0' and column '0': 'The template language expression 'if(empty(triggerBody()),null,triggerBody()['text'])' cannot be evaluated because property 'text' doesn't exist, available properties are 'text_1, text_4, text_6, text_10, text_11'. Please see https://aka.ms/logicexpressions for usage details.'.
Is there away i can alter the body of the HTTP request where it "bypasses" the fields if they are not there? Below is the body i have currently:
{
"jobTitle": "@{triggerBody()['text']}",
"department": "@{triggerBody()['text_1']}",
"officeLocation": "@{triggerBody()['text_2']}",
"businessPhones": [
"@{triggerBody()['text_3']}"
],
"mobilePhone": "@{triggerBody()['text_4']}",
"streetAddress": "@{triggerBody()['text_5']}",
"postalCode": "@{triggerBody()['text_8']}",
"city": "@{triggerBody()['text_6']}",
"state": "@{triggerBody()['text_7']}",
"country": "@{triggerBody()['text_9']}"
}
