Is there any way to limit the amount of characters in the comments box when approving? I am sending the comments to a single line column in Sharepoint which has a limit of 255 characters. I can't do a multi-line column because I need to use the column as a lookup. When an approver inputs more than 255 characters in comments on Flow and clicks Approve, the approvals are not going through. They are when the comments are less than 255 characters. So is there anyway to limit the characters in Flow?
Can you provide some insight as to why you'll be using the comments as a lookup column?
It generally isn't a great idea. If you make it a multi-line column your issue will likely be resolved.
I want to have a column hidden so a user can't update it. This column gets updated in the flow. And there is a second column which just equals the hidden column so the value can be viewed.
Any update on this? I also need to limit the approval comments because I'm feeding the response back into an InfoPath form read-only text field. InfoPath forces this field to be a single line text box in SharePoint, even though it's still multiline in InfoPath. The field has to be editable in SharePoint in order for Flow to dump the comments into, but InfoPath will not map to a multiline field that allows editing. It's a round-robin issue, and the only way I can see getting around it is to limit the characters in the Approval comments.
Join us for the first ever Power Platform Online Conference!
Look out for new contribution recognition badges coming SOON!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!