cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FH1000
Helper II
Helper II

Using the input from "add and input" "number in update file properties

I have a flow that is triggered on select a file in sharepoint. I also have a manual input number field in the trigger.

 

2020-03-09_12-55-02.jpg

 

The output from this input i want to use to update the file properties

2020-03-09_12-56-41.jpg

The client feedback field is a number field. The problem occurs when the manual input is empty - it can be.

Then the flow crashes because it is trying to update a numbers field with nothing.

Any good workarounds out there?

 

 

 

4 REPLIES 4
abm
Super User
Super User

Hi @FH1000 

 

Why not add an IF condition to check whether the field is empty? You could use empty or length expression to determine whether it has any value or not.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

@abm I was thinking about that but i was stuggling with writing the IF.... any pointers? 🙂

Try the below

 

image.png

 

empty(triggerBody()['number'])


Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

@abm That would probably work, what i didnt say is that i have 7 more fields like that. Is it possible to create the IF on field update instead? 

Something like 

IF
(triggerBody()[number_2]) is empty write 0, if not write (triggerBody()[number_2])

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,510)