Do you know if you can add a custom code in values (pink rectangle) - Bridge Workflow?
Do you know if you can add a custom code in values (pink rectangle) in this Bridge workflow that is updating a SharePoint list any time changes are being made in the relevant Smartsheet Table?
Basically this workflow is working as expected with one issue: for every empty cell, the workflow will update SharePoint with the code instead of leaving it blank. So for example if Area is changing but Department is blank then when the SharePoint list gets updated, the Area will update with the expected value but the Department will be updated with "{{states.startstate.smartsheet.get_row.row.cells.Department.value}}" which is not what I want to see. I would like Department to stay blank otherwise the SharePoint list becomes very messy.
I was thinking I could make it so anything in Smartsheet that is blank is actually replaced with a word like "blank" or "null" and that will solve my issue but I would love to just have it actually blank if possible.
Do you know if you can customise that in Bridge?
Thanks for any help or tips you can give.
Best Answer
-
Hey @AndreeaC
At the end of each value code but within the double curly brackets, insert two 'pipes' (the upper case on the key of the backhand slash). I enter this on all my values to prevent exactly what you are describing from occurring. You can see the two vertical lines just inside the ending double bracket curlies of a workflow I made just yesterday.
{{states.Get Row.date_time.format.formatted||}}
If your keyboard is a US qwerty layout, it might look like this:
Does this solve your problem?
Kelly
Answers
-
Hey @AndreeaC
At the end of each value code but within the double curly brackets, insert two 'pipes' (the upper case on the key of the backhand slash). I enter this on all my values to prevent exactly what you are describing from occurring. You can see the two vertical lines just inside the ending double bracket curlies of a workflow I made just yesterday.
{{states.Get Row.date_time.format.formatted||}}
If your keyboard is a US qwerty layout, it might look like this:
Does this solve your problem?
Kelly
-
Hey @Kelly Moore, yes this has sorted my problem and it was so easy! Thank you so much ☺️
-
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives