Hi,
I have an Excel online dataset which was pre-populated which is now connected to my PowerApp.
I was tasked to then add an additional column to the Excel table which will contain the new column 'Quantity'.
I can pull all the other columns with ThisItem.ItemID, ThisItem.Description, etc,.
However, I get an error when I call ThisItem.Quantity which is the newly created column in my workbook.
Some of the solutions which I have tried:
- Refreshing the OneDrive connection to the Excel workbook within PowerApps
- Opening and closing the workbook direclty and saving the workbook
- Deleting the connection to the Excel online workbook and creating a new connection
- Checking the spelling of my identifier on both ends, it is correct, no typos
- Have tried using both ThisItem.Quantity and ThisItem.'Quantity'
Anyone with a solution around this?
