Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 5RqWoc2E41Y1oXJkcKZlx/
Power Apps - Microsoft Dataverse
Answered

Maximum character count increased on URL column, but still getting "too long" error

Like (0) ShareShare
ReportReport
Posted on 26 Oct 2023 16:05:55 by 154

I have a dataverse table with a URL column, which was originally created with the Maximum character count set to the default of 100. After getting errors, I increased this to 500 characters, but I'm still getting the errors in the PowerAutomate flow which creates items:

 

 

The 'inputs.parameters' of workflow operation 'Add_a_new_row_-_movement' of type 'OpenApiConnection' is not valid. Error details: The API operation 'CreateRecord' requires the property 'item/abloads_outwardmap' to be a string of maximum length '100' but is of length '299'.

 

 This is how the column is set up:

RobHardy_0-1698336195512.png

I've tried publishing all customisations in the solution containing both the flow and the table.

Any suggestions welcome. Thank you.

  • ChrisPiasecki Profile Picture
    6,389 Most Valuable Professional on 28 Oct 2023 at 17:09:27
    Re: Maximum character count increased on URL column, but still getting "too long" error

    Hi @RobHardy,

     

    In general I would avoid deleting and recreating columns with the same name, unless they have not yet been pushed to downstream environments like production. It can cause your solution imports to fail and require you to do an extra solution import without the column to delete the old one, then reimport with the new one, but that will result in data loss still. So exercise caution.

     

    Assuming you already published customizations, the issue is likely stale metadata in the Flow. Usually the fix is to remove/readd the Dataverse actions that reference that column so that it retrieves up to date metadata. 

     

    ---
    Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

  • Verified answer
    RobHardy Profile Picture
    154 on 28 Oct 2023 at 11:11:39
    Re: Maximum character count increased on URL column, but still getting "too long" error

    Thanks for the response, @FLMike, but if you look at the error message and the screenshot, you will see that the logical name of the column matches (so same column), the "Save" button is  greyed out (indicating that it had been clicked), and definitely the correct table (which only exists at the moment in one environment).

    In the end, I deleted the column, and re-created it with the same name, which resolved the issue.

  • Michael E. Gernaey Profile Picture
    42,027 Super User 2025 Season 1 on 26 Oct 2023 at 16:13:03
    Re: Maximum character count increased on URL column, but still getting "too long" error

    @RobHardy 

     

    Hi, I definitely understand the frustration, and I know you said you did, but to me this feels like

    1) you updated the wrong field to 500 or at least this error is now a different field

    2) somehow you didnt click save on the change and then when you published it didn't publish correctly

    3) the flow is pointing to the wrong environment or wrong table.

     

    You could always remove the connector and re-add it to see if that solves, it, but if not, then it has to be 1 2 or 3.


    If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

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

Quick Links

Understanding Microsoft Agents - Introductory Session

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

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 15

#2
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

#3
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

Overall leaderboard

Featured topics

Loading started