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?
Thank you!
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
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