Forum Discussion
Djhoward97
Oct 12, 2022Copper Contributor
Power query manual parameters
Hi,
I am new to excel. I have a table connected to my outlook which gives me a list of orders from a shop. This list updates automatically when a new order comes into my inbox.
I have the subject, date and email in the table as columns. But i need to create an extra column with a drop down list where i can manually select the status paid or Unpaid. Every time when i refresh the status does not match the row of the order number.
I tried to create a table with a list parameter but with no success.
I would like to ask if it is possible to link a column with basic option paid or unpaid to the power query. where i can select it manually and when refreshed it remembers the position and status?
- Riny_van_EekelenPlatinum Contributor
Djhoward97 The article in the link below describes a method of how to achieve just that.
https://exceleratorbi.com.au/self-referencing-tables-power-query/