Answered

IF Null user input help

(0) Share

Report

Posted on by PowerBI87

Hi All,

I have a flow connected to a button in SharePoint. When the user clicks it they are prompted to enter links. The fields are not mandatory but if they do not populate the fields, the flow fails. I want to write an if statement in the create item step to avoid this.

Can anyone help with this?

Thanks

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

Rahber 1,935 on at

Like (0)

Report
Copy link

Link copied!

You can use this dynamic expression

if(empty(items('Apply_to_each')?['Status']),'Empty',items('Apply_to_each')?['Status'])

items('Apply_to_each')?['Status'] is my SharePoint variable int this case, you can replace with yours

Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.

Thanks,

Rahber

Was this reply helpful? Yes No
PowerBI87 38 on at

Like (0)

Report
Copy link

Link copied!

I tried this but its not working. Not sure if my syntax is off.

Was this reply helpful? Yes No
Rahber 1,935 on at

Like (0)

Report
Copy link

Link copied!

No Sir, not this way.

This needs to be a dynamic expression. and to know the expression for share point value however on the share point item and you will see the value that you have to use in dynamic expression

Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.

Thanks,

Rahber

Was this reply helpful? Yes No
PowerBI87 38 on at

Like (0)

Report
Copy link

Link copied!

I see, I am not able to grab dynamic content from "For a Selected Item", only "Get Item"

Was this reply helpful? Yes No
PowerBI87 38 on at

Like (0)

Report
Copy link

Link copied!

Tried this:

if(isblank(variables('FW')),'Empty',items()?[variables('FW')])

Getting error "
Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The template action 'Compose_2' at line '1' and column '9641' is not valid: "The template language function 'items' must have at least one parameter.".'.'"

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @PowerBI87

You can check out this post as well: https://www.bythedevs.com/post/how-to-pass-a-null-value-as-an-input-while-using-a-manual-trigger-in-ms-flow

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Rahber 1,935 on at

Like (0)

Report
Copy link

Link copied!

Use

if(empty(variables('FW')),'Empty',variables('FW'))

items()?[variables('FW')] is not a correct expression

Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.

Thanks,

Rahber

Was this reply helpful? Yes No
PowerBI87 38 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much for this!

Was this reply helpful? Yes No