Hello,
Which would be the best method to get Public Web Forms to PDF via Power Automate?
@Nikita_Kurguzov has previously helped me get signatures and Likert scales into Word document template via Power Automate via SharePoint Online forms however this method doesnt seem to work from Public Forms via Power Automate to word online template.
On my compose signature action I am getting this error:
Where the Input = replace(triggerOutputs()?['body/SF08_AppSig'],'"','')
and then the output on the next action = dataUriToBinary(outputs('Compose_Sig1'))
I then use the output of this into the correct field in the Word Online template.
I've tried also creating the outputs of the public form into a SharePoint list item first but am also encountering the same error.
Thoughts?
Dear @chris.cundy,
Could it be that this particular submission had no signature? It seems like it had a Null value instead of a string.
Yes, it had a signature.
Here's the base64 output from the Plumsail input:
"ApplicantSig": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAlgAAACWCAYAAAACG/YxAAAAAXNSR0IArs4c6QAAHe1JREFUeF7tnXvsNVdVhl/aCuVuRSoCBhEjiNZaRYmCtz8UIyaI8R7iB2m9oAJtlISQQIshAVIb5BKlahQ0UbzEWu8RY61posZLwQtpFVvRgEhRlIIICJq3316yujtzzpxz9syZmfNMcnK+7/xm9uz97D0z76y99lr3EhsEIAABCEAAAhCAQFMC92paGoVBAAIQgAAEIAABCAiBxSCAAAQgAAEIQAACjQkgsBoDpTgIQAACEIAABCCAwGIMQAACEIAABCAAgcYEEFiNgVIcBCAAAQhAAAIQQGAxBiAAAQhAAAIQgEBjAgisxkApDgIQgAAEIAABCCCwGAMQgAAEIAABCECgMQEEVmOgFAcBCEAAAhCAAAQQWIwBCEAAAhCAAAQg0JgAAqsxUIqDAAQgAAEIQAACCCzGAAQgAAEIQAACEGhMAIHVGCjFQQACEIAABCAAAQQWYwACEIAABCAAAQg0JoDAagyU4iAAAQhAAAIQgAACizEAAQhAAAIQgAAEGhNAYDUGSnEQgAAEIAABCEAAgcUYgAAEIAABCEAAAo0JILAaA6U4CEAAAhCAAAQggMBiDEAAAhCAAAQgAIHGBBBYjYFSHAQgAAEIQAACEEBgMQYgAAEIQAACEIBAYwIIrMZAKQ4CEIAABCAAAQggsBgDEIAABCAAAQhAoDEBBFZjoBQHAQhAAAIQgAAEEFiMAQhAAAIQgAAEINCYAAKrMVCKgwAEIAABCEAAAggsxgAEIAABCEAAAhBoTACB1RgoxUEAAhCAAAQgAAEEFmMAAhCAAAQgAAEINCaAwGoMlOIgAAEIQAACEIAAAosxAAEIQAACEIAABBoTQGA1BkpxEIAABCAAAQhAAIHFGIAABCAAAQhAAAKNCaxNYD1R0ndKOq9wukDSn0m6SdIfN2ZHcRCAAAQgAAEIQKCTwFoE1iWSXirp6zb085slvV6Sv29kPEAAAhCAAAQgAIGxCCxdYH2+pOdJeuYegP6wiK1fQ3DtQY9DIAABCEAAAhDoJbBUgfWVRVh9Q6O+/ZCk2yRdylRiI6IUAwEIQAACEDhhAksTWBZWV0ry96btHyX9m6THSPrEHfr39yQ9ZYf92RUCEIAABCAAAQjcg8BSBNanS3qlpE0Wq1vLPtcO6GeLLk8v+vPVyXfrtZKeM+B4doEABCAAAQhAAAK9BJYgsCyqfmaDJeoNkq6SZKvVvpsF18Mk3bJvARwHAQhAAAIQgAAEgsDcBdaPFl+rrh5rIawYCRCAAAQgAAEIQKA5gTkLLIdUONPR4uslXX6gxao5SAqEAAQgAAEIQAACc7dgdYmr/yzCyn9jgwAEIAABCEAAArMlMEcLVpe4cmBQ+2L9x2xJUjEIQAACEIAABCBQCMxNYHWJq1cVyxWdBgEIQAACEIAABBZBYE4CyysBHeMqb0+X5EjrbBCAAAQgAAEIQGAxBOYisJzqxqEYYnt7SX/jdDZsEIAABCAAAQhAYFEE5iCwXl0F93xLidSOv9WihhKVhQAEIAABCEAgCBxbYDnlzQ2pO15SgobSQxCAAAQgAAEIQGCxBI4psBw9/WZJToPjZMueJnzjYklScQhAAAIQgAAEIFAIHFNg2Xn9aaUeV0hy1HY2CEAAAhCAAAQgsHgCxxJY2andPldOuswGAQhAAAIQgAAEVkHgGALLYspTg94cnd3/PyRR8yo6gkZAAAIQgAAEILAeAscQWG+WdHFB+CxJpL5Zz3iiJRCAAAQgAAEISJpaYDndzXWFvJM2+/9sEIAABCAAAQhAYFUEphZY4djuqUGvHiTW1aqGE42BwKIIeCWz70MP3qHWH5N0p6RHSYrjXYY/sfm+Zku93R9uknTNDuWzKwQgsBICUwos34zeW7iRX3AlA4hmQOBIBHw/8XaRpHPKv0PwxN/8cy1+HHtv6u2rJJGVYmrqnA8CRyYwpcDK04PccI7c8ZweAjMkYIuPrUn+tkiKb1c1/t+y2k7JtWmBjf9ma1QWbI+W9FZJ/1qsVP67P7Hv50n6fUkPLRW9Q9IXs5CnZbdRFgSWQWBKgeU4V88rWKY87zJ6glpC4LQIWDx5sYu//dnVsmQ3A4uaB0h6j6R3JZETJGOqLv7v/cdcseyXSOdUDUFmAed2jXnO0xo1tBYCCyIwpdCxifwrJN24x810QUipKgQgUBHwNJ2v/aFiKixLIYiyULJv05x8N6NtFld50Q73OS4DCJw4gSkF1v8W1q+T9OwT507zIbBmApdJekQSVNkBPLfbVigLJr98hZhagq+SheKZ8qLYFSQZH9M1j27aBoGBBKYSWL7B3l7q9BpJzx1YP3aDAATmTyBbcTwlln2Wcu1t1bGQsogKUTX/1p2toa1TTu3l7772OfSMXSGWIBKXwp16QmCxBKYSWFdJurJQspMoPgmLHTJUHAJ3CQxP+VlM+dNlxXmnpDclC5UtVUvY3Db7hsXqQ7ftqZI+oafyFlUOP+PPnKYul8CaOkJg1QSmElgWVI4bQ97BVQ8nGrdiAhYcYcHpc0j3lJ8zM/gzd0Hl9vie5LaEmBrqaI+oWvFAp2kQaEVgCoGVcw9eUUzorepPORCAwHgEbM2xqLp8Q0J2i6qw4Ph7bpvvPxZS/raQCkf7Xet5qyT7j7qNWOB3pcf+EDhBAlMIrByegenBExxkNHlxBCxEPKXf52/kVX4WGvY1OqaoepKkb5T0tZI+IOl3JDnSehZT+8APXzELKVvi4nufsjgGAhA4UQJTCKxI7sz04IkOMpq9GAIhrJ7ZUeOwVPmFqfX0ny1MF1Qpa2w9i8jsrs75kr5c0mMl3b/8/xCwEQrCIjHCQMwtBMQh7eNYCEDgyATGFlh59eBLJNnZnQ0CEJgPAYuYb5f03T3TgH4xsqgKS5X3tyDKW1eU9a7ffD8I4ZSPdwiXse5FXUKKVX7zGX/UBAKrJTDWTS2A+U3YkY29kR5ntcOIhs2UQIiciEHnasZvjyuCyt9d2/vLj46U3mKLyOv1SrtIiuy/e/XehcU6NeTeFClqPD3458USFeIJa1SLXqMMCEBgbwJDbmJ7F17efEmPcwhBjj0VArGqLbe3niaLv9UJjP1712+HsLPlJ/LsRTldqWbC4Ts7fuf8fHUdIgyCV+x9qaQnSPqkARV1fSJ+lsVT62nKAVVgFwhAAALDCYwtsCI9Dv5Xw/vk1PfM00hhefFD+aOSvnBCOBFMMgeVtFXnXyR9SqnHOSUXXq6WLT7+PKyjrv7dxz6wcTu6khbnBMQ+nX2YntIxDWjrz69Luql8/qpR3SJxcwQetf+UhZT7932S7r3Fj8r3jCyoWLnXqGMo5v+tuL6/hJ9fvs6z9dPPSKaUGTR7ERhbYIWDO3m59uqe1R/kKeRry8N29Y3ds4FOYmxh5m+LpLdtKMcPiTwFFw+NTy6C77x07P9IcjDQ2/asV4g218n1i2+fI6YVLUi9qu/Dku4n6T6Szu05n+vjpM2uv7/9/2Nv5vPwY1eC8x9MIPrR14NXsof1sy/5d/YfrC3LIfTjOvO+b8C/+OA+WmUBYwussEDg4L7K4XNwo3zzepGkh6T0I75h+WHtT2yOou2x5Px2x9xi2iyEzD6Ru2PFWi2G+tqVb+j2T/q7HQBcIsmx5z6tOsYPhF+RFH5Wm4q0Jc5Wt88swsmWKQso/9/bP5Ry/NByee8o/Rmxp2K/rnP42LCcbRKOOzS56a62mvYJwqYnorBRCbgf72wwreyxX6dJ+ixJLy+5KX0OrF2jduWyCkdgLau/qC0EhhKwdfCV1QMh3rS7ptuc+qaOaB6RzSMpc07InN/+I22O42Z1pc2JOruciJ1FapmhPcl+cyfgMf9jkr5E0i9L+pa5V5j6TUMAgTUNZ84CgakI+A3bwirHsrLl7fmS3l3l2PPb9+NLxbpElP/U9UbuB4pFlQXVtvQy9qWKSO84pk81CjjPMQj8kqRvlnSzpC84RgU457wIILDm1R/UBgKHEPgyST+dpu9clh3KH1QK9RSefZs+Iumh1Yk8ndgngGzZ+jZJl0myP9eDN1QyO6dHEM9D2sSxEFgKga+X9BulsvYj/LmygIRpw6X0YON6IrAaA6U4CIxIIEIcxFRefHf5hrga9gkZsmLxDkm2ZtU+Zc5DaEuYLVV9G4JqxA6n6MURsE+hUzjl7S/KtegFII+U9F5JsfI3rrk85d61KnhxIKjweNGTg204uZPkmdEGge0EQkB5zwhvYL8Or76L8BUWNOEon7+/S9J39JwiYkiF75WtUU454+36IqLiRu/zOHadRZX/XW92TP/NFEJhH0f/7STYAwLLJeBr9/vKdOGhrYhrPMrpW/no9FH/XsLIxAKaiKPnY/J1esg164gAbAMJTGXBepak1w+sE7tBYK0EQkDFMvD4zkFCa18oRyj31F7XjfVbJTkS+5my/DxzsxDzNefpiZj683mcWSH8puz0bguV6xHWqi6fKgs0p8txeYfcnNfar7QLAl0EfL35+opFIGugxLN8h16cSmCRJmeHThl5Vzs1P7nE94lAjiOf8qSK9800x9EJS1ReXVdboXLC4U2wXFbcrPumBf+oCK68UtD1sVXq8rSq0HW4sliqNiV3DpF2Up1IYyEwAgHfex32xLHh8j2i/reF2SY/x66q2a/SH0/351ASu5aTy/bLXmRliBcr3ysI+jtwcEwlsDwl8YsD68Ru7QmY/xeVSN6f01G8p3x+XtIvtD/16kqMwINh6QmhU1t+bEoPq1P9PRSKz2XLksvu84P6rxLE02VaNHnfbGXqCtfgoKX37bmJu94WVYRRGNpL7AeBcQnEVJ/PUqevGvfMlH4QgakEFhasg7ppr4O3TfvUhXoqyiKM7WwspwiU2TWNF4yyiIr0GocmGQ5RZWHUFVPK03UWP7Z6eUXfT5bK+G3T+8fbpQWZLVSb4lJFO2IK0OXydsoVAAEIQKABAQRWA4gzK8IWDPvkdE37bKrqPxVRMbPmjFKd8IUK61PfarxYzRMWKIsn/7t1PKcQw57C6xJEdkQPURUCyHW+PdF5etnH/e84WNuEVQg1W6tat2eUTqNQCEAAAksiMJXAipv/ktgsra61A3Nf/R1p+Gcl/amkq4sY875eXuw4SmvZ6mTDWUTlNoaICsvTUH+oFpxCDNvaVKfgCFHVN1UXeT5dj2eUFDXuzydsqBiiqkWvUQYEIACBAQSmElisPBjQGQfsYmuVV4dt2n5Lkj8/nnbyA/6G9P+xx8MBTbzHoX0xofKKPB8Uq/Lq0AZ9y51b1rGrrHA4d5/VYRDsQ+XVetv8n64q038u38EMHcqhL+dfxKnCUjV2z1I+BCAAgQkfqH6I2ZeFZM/jDTs/kL1CrGvb9sDOAsurT5xMeC6bhUg4lOfAmp/bISb6VuXV8V+O2TYvNHBYhdpZ3QLQgsr9OHSqzgFEnXD5w5Lu3dEoBzL0ooUfwafqmF3OuSEAgVMmMLbFwtMtXlaOwBpnlN2SAkbmM3h6yVaObQ/sbAk5Rh/FNF74QtXfNTULKfuKOR1MtkiNQ7dNqRaxti7W1qpdV+tZcNq37gc2WKu8ovClkl7WpuqUAgEIQAAC+xKYSmC9qsTg2beeHHd3Ak4o+oqO4JJ+aO8Sp+SfS+oGl95ypWeOSF47kueYL5v61ZadCJK5xHhd7gcLohy+wQFDrylhEIau1hu6aMGi2k7yQ8vlmoIABCAAgREJjC2wPPXhOD5+8HdFiB6xaass2laQ55c0DLmBfy3puUWQDG14tl79SfHj2XZsl3Cqg2puK6Pv77ZO2eIWomqb9W3f84x5XFiZLHSyxcpi0VOA/gyJhN5XjhM1O59Z3uy4bjFHQtlxejb60f2WFyJEOpJ8VmIUjdMHlAqBRRIYW2DFQ9xv1Y9eJKH5VLp2SHfN/lbSpWVF4K41tbP795aDfkLS9/T4PEUOvG3L/nc5f4gpi6gQVbscP7d9I39fpJ3J9bP11tfBEGHlciK6ejzM3yHJOT2dJLZvi+nScNy32Aq/tCGsctwv1+GzJX1wyIEz28d5Eh/TUafw5zOnrvyKFqneWln/fI7o74sHMIp966jZAw4dvIvZnNsRqDLOWbfdz4ZDY7oNrhw7QmCNBMYWWHbova6Au2DgQ2aNnFu0KQsil+dwCy+U9LYdCw+/J68qi4eNI3s7hcMYm62XOX7Umm7aIYi6Yo45z5+F1ZCHtsWzhVVYecPx3f1hC3AdwsHC2g/Mm0uHhYCIiM/xUM+CK/dtHYU+pmP9sLU4e7ck+3MtbbOFz9OwYwqVqZnEC47Pm61oMSZqy1pf/bL1M8qsx1VX+qVYaJLL9Tk3LSDZtEK3Tl6cy0XUTT26ON+oBMYWWL6AvaLJG7Gw9u9K3+T8QD2nFGFH5hdtKC4H0vSxvnHW4Qv2r809j4xQCMeIJdWyHUPLMl8LIk8F1pstVp4K3CSsfLwXf/gFxGInhG7EvvJDyMFCa2vLLtOBUW6U4e9cp1aR54cyY7/1EOjzo+y7x4SQ67KCx8vBtpx5XS9mXb/VU+W7WHLX00O0ZBYExhZYbmQERPTDoy+f2ixgzLgSXaEY/LC0Fcpb7Ug+RlPqUAin+oC2VcphMfLb/xAfq0iBk/MKhjD9gxL81cLKKw7r68TCyueN/h6jfykTAnMiENbY+iUjW2ujvl2/dVne4nmUp+tra1vc17CmzWk0LLQuUwisHASTacL9BsqQQKL7lfzxo+JhHzec2q/n0PKXfnxfChqHt+hzXvcxnuKzYIoHRUz/ReqbuNm7DK86rIWbhZX/xgYBCOxPoLa61da2rv87hmNsMSXq69c+kfWWFzhssl5HOV0+mS57TrH79qfNkXcRmEJgeWB70NgEfIxYS2vp6phO8ne+8HdpX4iovBrwWkkvwD9uI8a84jJ27PKxMlcLqrBShVjaFE3dAUhfUxI3R9lDLGK79Dv7QgAC+xPIFrL7leC+2TcuSu6aIu2zpO1Sm9rK1rUwod4n7vW7nId9GxOYQmC5yp7a8Nu5B4atWGyHEbBFKwRX+C54Gsl8/1vSg4rz+1+mlUDZNyECwLoWiN7uvohQCc7zl/P7mbN9r2yB8ubp2bBSZR8TT4mbs/er32j7wjC4bFurfL0MWXV42CjiaAhA4BgE6pBFtTCrrW35hfiQ+tY+a0OEG1a1A4hPJbA8gG4v9SQv4QEd1ujQSGHk4loGGG1UvaMW45uZfawsosICFSuwLEYtmOyg7pukP7GPxVEIqhBfdUOi7DoPoVPfWFi9+Kgt5+QQgMASCHQJsGxR28UnbUh7/bJnK3xMjcYLY0xnRsxC3wOHrJoecs5V7DOVwDKssGIRE+v4Qyf7EDg+GRfF2T6xVbBevWc2Fk5OpvzkquscgiJ8qTYFRu2Kb+WifHwkdz7+qKAGEIDAKRHoCstR/2axFtb0EHYRTy4WItQrQH1PvILnyjQ+WDFgsWLN49LNAUtt/q1j4cyjltPX4ockXV1O62lWb+enavjtLEeaHxI5vS9O1tBckdNT4IwQgAAEdidgYfbYEk/RfqWPk/QxST94yqufp7RgZSvW30i6aPc+5IgGBH44xdC6tVwIDYpddBFhXY1G1GJq1+CoXdOMLnuX4KOLBkrlIQCBVRDITvpd4YD8wh5Tg7HyPJzwHbvR+W5PdoZkaoGVrScEHj3O9fdqSc8pp/YF4KmvU988Lr9J0u9KuulAB3NPMzqWVbYMIqxOfYTRfgjMi0CXcMq+XSGm7MbgLRzis2P8ECv+vFo9cW2mFlhunhMLP7FMt9jBmtVS03Z6Frkk4W7H3jenOkio+TrEAzeidpwpCQIQ+DiBrjAQeZViFk353znCfdyf4ntTOiPY70DgGALLyjhyqBEiYIfOarQrAqsRyFSMVwXaOT6sVvZtI0Boe86UCIElE6hX93mxUdwz6jRCXTG18vFd4RO6hFF+udvV1WHJrGdR92MILDc8Ur94QFxyynO0RxgFOSo8FqzDOsBi1VarnM7DuQgtrrDMHsaWoyEwNoGcp7MrOnv+e1dd/Hdf5xdKuqMSS9lFIEd5j+TcfRHdYzXypnQ+Y3Oh/EYEjiWwXH0PIC/vtML2VCHbNARyXkOLga6ExdPUZLlneZKka8pUd7TifZI+IOlTd2hWXwJbFxHJmY8h1OKcQ9N2+G06H7MDAnY9cQKx1N/jvUvkGE9XXKeMrY4Lte1vm+I1bUpl4zEeDtv5uvxoceaO345xzZ74MJpn848psLIlheCj042PSL7tM7LQYD/u75H0kP0OPcmjPijpvlXL/aAKEZlj7cQbfrz157+dJLyBjX6npIcP3Hes3UIshfVmUwiYyDyxSYxs8gXqSheT27VJKI3VfsqFwN0IHFNguSKRssUXiwNeovzHH6D5LZHk2/vxfqOkp0p6wH6Hz/6osEjlqY1Nlc77dS3Jvn+x7u3T8Hhoh/AK614+Z56i3ecc9TFRdhZ73ufQ+1PNpqWItBXl3BaN7xDC/qlP6J7sEvwRWFPkyggcW2Blh3dHf7VFhW08AtnB3W+QrR9M49V8niXb18rb4yW9VdJtkj5jYFVjuqF+aOOIOhAgu0EAAhCYM4FjCyyzsQ+QV2B5c8BHTxeyjUOAFYTjcKVUCEAAAhCAwN0IzEFghbA6k0SW8xgdao6nq+9J4KckXVp+fp2kZwMJAhCAAAQgAIH2BOYisGqR5WkSW7I2JdBtT2P9JdoRNla5vULSC9bfZFoIAQhAAAIQmJ7AnASWW2+flisLBluwPH3oNCNshxPI04Pvl/TAw4ukBAhAAAIQgAAEugjMTWC5js7lZl8sx8jyZud3W7OYMjxsDJvj00oRxL86jCVHQwACEIAABDYSmKPAcoW9JNgiKwTBnZJeXCLA06W7E8jWKx/tkBgsr96dI0dAAAIQgAAEBhGYq8CKytua5cjjjyo/OG6WHeDxzRrUvXft5FAMzv0YQf885eogr2wQgAAEIAABCIxEYO4CKwTCr5achYHBosuJopk23D4wcuR2B5B07DGsV9u5sQcEIAABCEBgbwJLEFh91iyLBDvF4wTf3/0RKT/2ICXR3pcKB0IAAhCAAASGE1iSwIpWWVR5dWE4wVtEWDhglbl7v79W0vennxBXw68L9oQABCAAAQgcRGCJAssNrp3g/Zud4j1tiNCSaqf2F0p62UEjhYMhAAEIQAACEBhMYKkCKxpoIWFhFU7wIbQckuD6wRTWtaN9rG5ITu1vkvQ162oirYEABCAAAQjMm8DSBVbQ9ao4Tx1moWUHeE8f+nPjiaw8tOC8Lomrt+isNYvFAPO+DqkdBCAAAQisjMBaBFZ0i8M6WGxF/KzcXSG4/r6Ird9ekfDwlKkTZufwC14x6BANiKuVXbQ0BwIQgAAE5k9gbQIrE7fYsvXGn4t7usLiw2EM/LGl6+0LtHRdLemyZLVyU72y0gsBEFfzvwapIQQgAAEIrJDAmgVW7i5beCy07J/0DEkXbsjFF6IrphctuubmOG/L1JkirB6ZGuqpUE+Vuu5sEIAABCAAAQgcicCpCKwuvBZdFlwhvPzv7MNVHxOixdausAyF8PL/z5f0Lkn2exrLcmSrnIWVv/P2IUkvL+LqSEOJ00IAAhCAAAQgEAROWWD1ia4QXPEd8bZ2GTUWXv6EGAurWFcZ4SdlwXdBEWr3KTv6N/89LHD18V4p6RWTXknJBgEIQAACEIDATAggsLZ3hAVO/ljshPDJR3uf8yQ9YnuRB+1hC5kFlYXV3KYuD2oYB0MAAhCAAATWQgCBNU5PhvUrpiEj0XJ8x1nrqcSLJH1E0i2pWmEFC2d8RNU4fUapEIAABCAAgWYEEFjNUFIQBCAAAQhAAAIQOEsAgcVIgAAEIAABCEAAAo0JILAaA6U4CEAAAhCAAAQggMBiDEAAAhCAAAQgAIHGBBBYjYFSHAQgAAEIQAACEEBgMQYgAAEIQAACEIBAYwIIrMZAKQ4CEIAABCAAAQggsBgDEIAABCAAAQhAoDEBBFZjoBQHAQhAAAIQgAAEEFiMAQhAAAIQgAAEINCYAAKrMVCKgwAEIAABCEAAAggsxgAEIAABCEAAAhBoTACB1RgoxUEAAhCAAAQgAAEEFmMAAhCAAAQgAAEINCaAwGoMlOIgAAEIQAACEIAAAosxAAEIQAACEIAABBoTQGA1BkpxEIAABCAAAQhAAIHFGIAABCAAAQhAAAKNCSCwGgOlOAhAAAIQgAAEIIDAYgxAAAIQgAAEIACBxgT+D48FE+Jy7kxNAAAAAElFTkSuQmCC",
Dear @chris.cundy,
Just tested the flow with the same setup as for SharePoint:
Everything works the same way:
Make sure you're using the correct field inside the replace() expression:
Because you say that your input is replace(triggerOutputs()?['body/SF08_AppSig'],'"',''), while in another post the field name is ApplicantSig
Hi @Nikita_Kurguzov , that was it - triggeroutputs! (thanks!)
In the other post, the column name is different as a different form.
The only issue I'm having now is that Im getting an "InternalServerError" message on the "Populate a Microsoft Word template" when I have the outputs of "Convert Sig1" - which means the workflow is hanging at that step.
Is this because I'm taking the submitted form to SharePoint first rather than going straight to PDF?
Thanks
Dear @chris.cundy,
I don't know what's the cause, I don't see the whole flow, just a part of it. What you're showing shouldn't cause an issue.
Please, show a complete flow and the errors you're getting.
OK @Nikita_Kurguzov,
Do I need to convert the signature from Plumsail before inserting the outputs directly into the SharePoint fields first? or does the below look correct?
As I am then using the compose and convert actions below to output into the Word Online action:
Dear @chris.cundy,
As I've said, this part is not really relevant. You can put it in SharePoint, it doesn't change anything. Where's the error? What's the error? What are the other actions you're using in this flow?
Hi @Nikita_Kurguzov ,
There is no error as such - everything runs correctly until the Microsoft Word Template action...
The flow runs successfully if I take out the "Convert Sig1" and "Convert Sig2" Outputs from the relevant fields in the Word document action.
The remaining "Apply to each" actions do the same as above.
This is the Word document template bit that is hanging with the "InternalServerError" message..
Dear @chris.cundy,
I don't think this is something we can help with. Internal Server Error can mean a variety of things, from there is something wrong at the server, try again later, to this action is too complex and cannot be processed.
I would recommend testing this with fewer steps, just to make sure that it works in general. For example, just one signature. This will test if the approach works in general or not.
This might be worth contacting Microsoft for support. It's also entirely possible that the Microsoft Word connecter doesn't support documents of such complexity, or with this much data, as each signature is an actual image file.
As an alternative, I could recommend using our Plumsail Documents product, specifically dedicated to populating documents with data - https://plumsail.com/documents/
It's quite easy to setup, can generate docs inside Power Automate, or directly from Public Web Form submissions, and we can offer support for it.
The problem is that it works with the SharePoint Online app to populate word documents for all my other flows. It's just this one flow that I had to create a form using Public Web Forms.
I will try creating the flow without creating an item in SharePoint and just going straight from Plumsail to PDF.
Will update on what I find.
Dear @chris.cundy,
This really shouldn't be related in any way, but yes, do experiment and see what works. I would recommend starting with simpler flows which will work, and then try building on top of that.
If nothing works, try Plumsail Documents, we'll support you with the setup.
Hi @Nikita_Kurguzov ,
I'm suspecting its a problem because the image data is coming from outside of our tenant.
As you can see I've made the workflow a bit more simple however the same InternalServerError issue is occuring.
I have one more theory about getting this working and then will give up if that doesnt work.
Dear @chris.cundy,
There's a chance that there is simply a problem at Microsoft's server that's processing the requests. It really has no way of knowing whether the data comes from outside of the tenant or not.
