Forum Discussion

Djhoward97's avatar
Djhoward97
Copper Contributor
Oct 12, 2022

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? 

 

 

Resources