Answered

How to fill in or ignore blank fields in Sharepoint list

(0) Share

Report

Posted on by dunecat Microsoft Employee

Hello,

I'm working on a flow that triggers when a new sharepoint list item is created (from a form), but running into issues when certain fields are blank.

The form has several options that pull up different fields for the user to fill out, so there will be fields that they don't see depending on what they choose.

When a field is blank, it gives me the error below on one of these actions: Start an approval; Create a work item (VSTS); Send an email from a shared mailbox

"InvalidTemplate. Unable to process template language expressions in action 'Start_an_approval_2' inputs at line '1' and column '2562': 'The template language expression 'triggerBody()['PageURL']' cannot be evaluated because property 'PageURL' doesn't exist, "

Is there a way for me to either ignore or fill out the blank fields using flow? Or is that something that needs to be done with the form - e.g. if option1 is selected, set 'PageURL' to "n/a"

Thanks in advance for any suggestions.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-yuazh-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @dunecat,

You could use expression below to solve the problem:

if(empty(item()?['PageURL']),null,item()?['PageURL'])

Please refer to link below to solve your problem.

https://powerusers.microsoft.com/t5/General-Flow-Discussion/change-null-to-blank-for-choice-values/m-p/153530#M15623

Best regards,

Alice

Was this reply helpful? Yes No
v-yuazh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @dunecat,

Have your problem be solved according to my solution? If yes, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,

Alice

Was this reply helpful? Yes No
dunecat Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Alice,

I ended up changing the initial trigger and adding a "Get item" step to solve for a different problem. This seemed to fix my blank fields issue as well so I did not need to use the expression.

Thanks for your response!

Was this reply helpful? Yes No
puttrian91 4 on at

Like (0)

Report
Copy link

Link copied!

@v-yuazh-msft

your expression is correct ..
thankyou

Was this reply helpful? Yes No