I have built a Power Automate flow that pulls information from a table in a CSV file, and populates the data to a Sharepoint list. When creating a new record, it works as expected. But when attempting to run an "update" to an item that already exists in the SP list, I get the below error. If I change the column in the SP list to a "single line of text" type, it works just fine. However, I would like the columns to be "number" type, so that I can apply conditional formatting to values that are less than zero.
The API 'sharepointonline' returned an invalid response for workflow operation 'Get_items' of type 'OpenApiConnection'. Error details: 'The API operation 'GetItems' requires the property 'body/value/0/VAC_Used' to be of type 'String' but is of type 'Float'.'
Any filter query expression written for this in Get Items action ?
Was this reply helpful?YesNo
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.
30
Share
Report
All responses (
Answers (
