Skip to main content

Notifications

Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Using Flows / Create Item failing du...
Power Automate - Using Flows
Unanswered

Create Item failing due to SP character limit, but limit already increased and will not sync with Power Automate process

(0) ShareShare
ReportReport
Posted on by DreaKeppler 6

DreaKeppler_0-1668007020082.png

This is the error I am getting, BUT I have already updated the SP column to "multiple lines of text" and an upper limit of 1,000 lines. I made the update yesterday and Power Automate and SP still are not communicating the change.

 

When I submit the form with 255 or fewer characters for that column, the flow functions. When I manually input more than 255 characters into the SP column, it saves.

 

Form details: the question on the Form that populates the column has a preset list of options and users can select as many as they need.

 

What am I missing? Please help. I need this to work by the end of the day. 

  • Pstork1 Profile Picture
    Pstork1 66,015 Most Valuable Professional on at
    Re: Create Item failing due to SP character limit, but limit already increased and will not sync with Power Automate process

    I understand the frustration, but that is the only solution I know of to fix your issue.

  • DreaKeppler Profile Picture
    DreaKeppler 6 on at
    Re: Create Item failing due to SP character limit, but limit already increased and will not sync with Power Automate process

    I cannot test that right now because the process is live and being used. Also, since the Create Item that is failing is at the top of the flow, that removes all the SP related dynamic content I have in the rest of the flow so I'd have to redo all that and can't have that much downtime for the tool right now.

  • Pstork1 Profile Picture
    Pstork1 66,015 Most Valuable Professional on at
    Re: Create Item failing due to SP character limit, but limit already increased and will not sync with Power Automate process

    Did you remove the existing connection and create a new one?

  • DreaKeppler Profile Picture
    DreaKeppler 6 on at
    Re: Create Item failing due to SP character limit, but limit already increased and will not sync with Power Automate process

    It has already been overnight.

  • Pstork1 Profile Picture
    Pstork1 66,015 Most Valuable Professional on at
    Re: Create Item failing due to SP character limit, but limit already increased and will not sync with Power Automate process

    That has not been my experience or what I've seen reported by other people.  If you were using the connection in Power Apps you would need to manually refresh the connection in the app.  But there is no option for that in Power Automate. If the schema changes in the Flow I've always had to create a new connection and wait overnight for the cache to age out, unless I was using a Connection reference.

  • DreaKeppler Profile Picture
    DreaKeppler 6 on at
    Re: Create Item failing due to SP character limit, but limit already increased and will not sync with Power Automate process

    Whenever I've made updates to a SP column, either through creation or changing its settings, the only thing I've ever needed to do it refresh the browser Power Automate is in and the additional data/columns/settings would sync. This hasn't synced since yesterday despite refreshes, restarts, clearing caches, etc.

  • Pstork1 Profile Picture
    Pstork1 66,015 Most Valuable Professional on at
    Re: Create Item failing due to SP character limit, but limit already increased and will not sync with Power Automate process

    The problem is that changing the SharePoint schema after you've created the connection doesn't update the connection.  The flow still thinks that field is a simple text field.  There is no easy way to get it to use an updated connection.  If you create a new connection it will still tend to use the cached version for about a day.  You can delete the old connection entirely and create a new one, but that is a problem if that connection is used by other flows.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,700 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,015 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans