Microsoft Forms -> SharePoint - > Power BI

%3CLINGO-SUB%20id%3D%22lingo-sub-1774831%22%20slang%3D%22en-US%22%3EMicrosoft%20Forms%20-%26gt%3B%20SharePoint%20-%20%26gt%3B%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1774831%22%20slang%3D%22en-US%22%3E%3CP%3EI%20can%20create%20a%20Form%20with%20up%20to%20400%20characters%2C%20but%20the%20limit%20in%20SharePoint%20is%20255%2C%20even%20if%20I%20could%20make%20higher%20in%20SharePoint%20the%20SharePoint%20List%20feature%20will%20only%20allow%20255%20to%20be%20transferred%20to%20Power%20BI.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20nothing%20to%20stop%20the%20user%20from%20putting%20more%20than%20255%20in%20Forms%20BUT%20the%20admin%20of%20Power%20BI%20gets%20a%20failure%20message%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20have%20400%20across%20the%203%20platforms%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1803364%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Forms%20-%26gt%3B%20SharePoint%20-%20%26gt%3B%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1803364%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F830468%22%20target%3D%22_blank%22%3E%40Gary_Gray%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20SharePoint%20list%20you%20can%20change%20the%20type%20of%20the%20column%20from%20%22single%20line%22%20to%20multiple%20lines.%3CBR%20%2F%3EThere%20is%20also%20a%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fmicrosoft-forms%2Fforms-with-flow%2Fm-p%2F1220035%22%20target%3D%22_blank%22%3Etech%20community%20post%20to%20this%20question%3C%2FA%3E.%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20should%20solve%20the%20issue%20and%20the%20flow%20should%20continue%20successfully.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EHope%20this%20helps%20and%20regards.%3CBR%20%2F%3ELars%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I can create a Form with up to 400 characters, but the limit in SharePoint is 255, even if I could make higher in SharePoint the SharePoint List feature will only allow 255 to be transferred to Power BI.

 

There is nothing to stop the user from putting more than 255 in Forms BUT the admin of Power BI gets a failure message

 

Is there any way to have 400 across the 3 platforms?  

2 Replies

Hi @Gary_Gray 

For SharePoint list you can change the type of the column from "single line" to multiple lines.
There is also a tech community post to this question.

This should solve the issue and the flow should continue successfully.


Hope this helps and regards.
Lars

@Lars365 Hi When I use Multiple lines the data does not transfer to Power BI correctly from SharePoint and the multiple lines of text are unreadable, which is why I used single lines