Showing results for 
Search instead for 
Did you mean: 
New Member

List rows present in a table unless already exists

Hi all,


I am creating an Scheduled Cloud Flow that takes data from an Excel spreadsheet (which is populated by forms) and places the data in Lists. It should be a very simple flow but I cannot get my head around it. 


Every time a form is completed the data gets put into Excel, each submission has a unique ID which is shown in the first column. 

The flow is set to run every minute. The idea is to have the flow's 'Key Column' set to ID so that whenever that field is filled out the entire row is added to Lists. I am just not sure what to have 'Key Value' set to, I can set it to one single ID but it will only take that one entry, so how to I set it to all? 


Any suggestions? 





Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,780)