We have a requirement to create a flow on "Excel to Sharepoint data", so whenever data gets update, add or delete in excel, changes should auto reflect on Sharepoint list.
And problem is: there is a column in excel having following data:
If I choose Number or currency type field in Sharepoint list, flow gets failed where the values are like this: "OA-$0.00"
Any suggestion, what type of column I should choose, and if column needs some sort of settings, then what it should be?
Go to Solution.
Because the Excel field contains a mix of digits and text characters the column will need to be of type text.
Ellis____________________________________If I have answered your question, please mark the post as Solved.If you like my response, please give it a Thumbs Up.
View solution in original post
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.