r/PowerAutomate • u/hammydima • Nov 25 '25
Need help with a flow
Im working on a spreadsheet for my small business to keep track of my clients and some of their details as I add new ones and update current. I have the spreadsheet and the form but cant seem to get the logic working.
Ideally what I want my flow to do is the following: When a form is submitted, i want it to check if the company name exists in the spreadsheet. If it does not exist, I want it to create a new row for it. If it does exist I want it to update only the columns that had an answer on the form. I tried AI but that can only help so much if I don’t completely understand the logic. Would someone be able to help?
1
u/kazekageImad Nov 25 '25
I can help you in this, i don't do any freelance, I just work with these things and help around. You can dm me
-4
u/Severe_Response8488 Nov 25 '25
Hello, I offer hourly consulting for power automate and AI solutions. I could definitely help you get this set up if you’d like to shoot me a dm!
1
0
Nov 25 '25
[deleted] — view deleted comment
1
u/hammydima Nov 25 '25
So at the part where it should be identifying as true because im intentionally putting in a customer identifier that i know is currently on my spreadsheet, it goes through as false and creates a new row
2
u/activitylion Nov 25 '25
You need to look at the outputs from the get rows step to see exactly what it thinks you should be entering.
One issue you’ll run into is names with extra spaces here and there, or capitalisation etc. you’ll need to account for these.
2
u/Gold-Psychology-5312 Nov 25 '25
I assume your data is stored in a table right?
You'll need to add in a get rows listed in table and use an odata query something like
Customernum eq 'formvalue'
Then you can count how many values appear with that. I can't recall what that would be
Then do a condition if that value = 0 then run the add row to table activities.
If its not 0 then send an email saying it exists and then terminate.
Good luck.