admin管理员组文章数量:1317898
I have a flow that is working with multiple 'formatdatetime(triggerOutputs()' when they are ALL filled out on the Plumsail form, but when I don't fill in one date the flow fails to work and I receive this message:
InvalidTemplate. Unable to process template language expressions in action 'Start_document_generation_process_with_json' inputs at line '0' and column '0': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'.
The expression I am using is:
formatDateTime(triggerOutputs()?['body/EOWD'],'D')
image description
I have tried using: coalesce(formatDateTime(triggerOutputs()?['body/EOWD'],'D'), '') but I am not sure if I have inserted it correctly
I have also tried using: if(equals(triggerOutputs()?['body/EOWD'], null), formatDateTime(triggerOutputs()?['body/EOWD'],'D'))
But I receive the following message:
InvalidTemplate. Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language function 'if' expects three parameter: the condition to test as the first parameter, the value to return if the condition is true as the second parameter, and the value to return if the condition is false as the third parameter. The function was invoked with '2' parameter(s).
I would really appreciate any help on this as i've been working on it for weeks!
Thanks
I have a flow that is working with multiple 'formatdatetime(triggerOutputs()' when they are ALL filled out on the Plumsail form, but when I don't fill in one date the flow fails to work and I receive this message:
InvalidTemplate. Unable to process template language expressions in action 'Start_document_generation_process_with_json' inputs at line '0' and column '0': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'.
The expression I am using is:
formatDateTime(triggerOutputs()?['body/EOWD'],'D')
image description
I have tried using: coalesce(formatDateTime(triggerOutputs()?['body/EOWD'],'D'), '') but I am not sure if I have inserted it correctly
I have also tried using: if(equals(triggerOutputs()?['body/EOWD'], null), formatDateTime(triggerOutputs()?['body/EOWD'],'D'))
But I receive the following message:
InvalidTemplate. Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language function 'if' expects three parameter: the condition to test as the first parameter, the value to return if the condition is true as the second parameter, and the value to return if the condition is false as the third parameter. The function was invoked with '2' parameter(s).
I would really appreciate any help on this as i've been working on it for weeks!
Thanks
Share Improve this question asked Jan 22 at 15:43 Jonathan HughesJonathan Hughes 1 2 |1 Answer
Reset to default 0if(equals(coalesce(triggerOutputs()?['body/EOWD'], ''), ''), '', formatDateTime(triggerOutputs()?['body/EOWD'], 'D'))
... written from my phone so untested.
本文标签: power automateMultiple formatdatetime(triggerOutputs() Not WorkingStack Overflow
版权声明:本文标题:power automate - Multiple formatdatetime(triggerOutputs() Not Working - Stack Overflow 内容由网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:http://www.betaflare.com/web/1742035767a2417282.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
triggerOutputs()?['body/EOWD']
is null, what do you want to replace it with? Just an empty string? I want to be clear on that. – Skin Commented Jan 22 at 19:55