Solved: How can my flow handle both integer and string inputs?

How can my flow handle both integer and string inputs?

Hi all,

I have a flow that processes the submissions from MS Forms, and looks up customer detail from an excel spreadsheet. I need a customer reference number as the key value to start the process. The form has a field for the customer to input their reference number, however to avoid typo errors I extract the reference number from their login details, rather than their input in the form.

This works great until a staff member completes the form on behalf of a customer. The flow won't be able to find any customer details from the excel spreadsheet using the staff name. This causes an error in the flow (excel - 'get a row'), so I use the 'configure run after - fail' option to initialise a back up process to extract the key value from the input field on the form, and then run (excel - 'get a row 2').

This approach is laborious and messy. It means I have to create the entire flow twice, once for the first input method and a second time for the back up method.

Logically I should be able to initialise a new variable and input the correct key value. So I would only need to run the subsequent process once. I would just need an 'If - Then' process to determine which key value should be used. However all my attempts at this have failed because the Customer references are 7 digit numbers, and staff references are letters.

So my question is this: How can the flow determine if the key value is a customer number (integer) or a staff name (string)?

I've tried changing the variable to an integer (This would work for customer numbers and fail for staff names.) However when this fails it doesn't go to the next step, but crashes the flow entirely.

I've tried adding 1 to the customer number (to determine if it is a number,) it works if the value is a number but fails if it is a string. However as above this also crashes the entire flow, and won't proceed to the next step.

Surely there must be a way to handle both string & integer inputs without crashing the entire flow?

Quick Links

Leaderboard > Power Automate