Skip to main content

Notifications

Power Automate - General Discussion
Answered

Power Automate error with Airtable connector

(0) ShareShare
ReportReport
Posted on by 24

I am trying to create a record in Airtable through my flow in Power automate. 

Error message: Field "kW DC" and "Opportunity" cannot accept the provided value. Please what am I doing wrong?

 

emea234_0-1678066448065.png

 

Thank you!

 

  • emea234 Profile Picture
    emea234 24 on at
    Re: Power Automate error with Airtable connector

    emea234_0-1678215391985.png

     

  • emea234 Profile Picture
    emea234 24 on at
    Re: Power Automate error with Airtable connector

    Thanks Cheng! The first part is solved!!!

     

    So, I went in and changed data types. Size to int(size) and projectname to str(projectname). Now I am getting a new error: Value is not an array of record IDs

  • Verified answer
    Re: Power Automate error with Airtable connector

    Hi @emea234 ,

    The error message you received suggests that there may be an issue with the data type or format of the values you are trying to populate in the "kW DC" and "Opportunity" fields in Airtable. Here are some troubleshooting steps you can take:

     

    1.Check the data type: Ensure that the data type of the fields "kW DC" and "Opportunity" in Airtable match the data type of the values you are trying to populate. For example, if the "kW DC" field is a number field, make sure the value you are passing is also a number.

     

    2.Check the field name: Double-check the spelling and case sensitivity of the field names. Make sure that the field names in Power Automate match exactly with the field names in Airtable.

     

    3.Check the formatting: Ensure that the values you are trying to populate in the "kW DC" and "Opportunity" fields are formatted correctly. For example, if the "kW DC" field requires a decimal point, make sure you include it in the value.

     

    4.Check for any restrictions: Some fields in Airtable may have restrictions on the type of data that can be added. For example, some fields may have a maximum length limit or may only accept certain characters.

     

     

    Best Regards

    Cheng Feng

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard