Uploading Data to Smartsheet Using MS Power Automate
Hi All
I have a client that does not want to use Data Shuffle and wants to use MS Power Automate to load to Smartsheet Sheets. When this is tried it formats the all the data entries with what appears to be a left justified tick at the beginning of the data. As such it turns numbers into text which creates an issue for formulas and calculations. Has anyone ever had this issue, is there a way to avoid the formatting? In the short term I have done a work around by using =Value(). Open to all suggestions and help.
Steve
Answers
-
I encountered this exact situation when using Power Automate to push data into Smartsheet – the numbers were indeed automatically converted to text with quotes ('), causing the formula to not work properly. This is Smartsheet’s auto-formatting mechanism when receiving string data from the API. The workaround like you using =VALUE() is fine, but you can also consider reformatting the data before sending, or using an intermediate script to ensure the value is properly coerced.
