web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power Automate error w...
Power Automate
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!

 

Categories:
I have the same question (0)
  • Verified answer
    v-chengfen-msft Profile Picture
    Microsoft Employee on at

    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

  • emea234 Profile Picture
    24 on at

    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

  • emea234 Profile Picture
    24 on at

    emea234_0-1678215391985.png

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 592

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard