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

Get Excel cell value from one column when the row value of another column is empty

I have a series of one time use codes in an Excel file hosted on OneDrive that I need to provide to users in our organization as requested. I am building a flow such that once an MS Form response is received, I would like to:

1. Get the next available (unused) code from column A and use it as dymanic content in an email

2. Update the row value for column B with the form respondent's email address, as taken from dymanic text of the form.

 

I've got the form response trigger done, and an email prepared with everything but the code value (from step 1). I have no Idea how to do the work on the Excel side to get the value from A or populate the value in B.

 

Any help would be greatly appreciated!

7 REPLIES 7
Community Support
Community Support

Hi @jogilvie,

 

Could you please share more details about the Excel file which is hosted on OneDrive?

 

Does the Excel file have a table and have only one rows for it?or if the excel table have many row,which row you want to have operation on it?

 

I have made a test on it, you could refer to screenshot below to create the flow:

Capture.PNG

Capture.PNG

 

Note:

The Condition in my flow is to get only one row which I want to have operation on.

 

 

 

Best regards,

Alice

 

 

Hi Alice,

 

 My Excel file has a table with 5 columns.

 

Column A: a series of row values representing available license codes available to students

Column B: currrently empty. Will contain student first names

Column C: currently empty. Will contain student last names

Column 😧 currently empty. Will contain student ID numbers

Column E: currently empty. Will contain student email addresses

 

Table Image Here

 

My flow currently populates dymanic content from a MS Form, with survey respondent informaiton forming the data I would like to populate in columns B-E. What I am hoping to do is have the flow identify the next available code (i.e. no values in cols B-E), then return the code value back to the flow for integration as text in an email. I would then like to populate the appropriate row values for that code at columns B-E.

 

I've got the flow to parse out the respondent information and create the email with all but the appropriate code, so the Excel work in the middle is my stumbling point.

Hi, @v-yuazh-msft

 

I have the same question.

 

How do I update the flow, if I have list of rows with available (unused) codes, so that when the form is filled the next time I get the next available code? I need column with unused  codes as auto-number the "Number" column but with increment last number like NUM0001, NUM0002

 

Thanks for help

double

Anonymous
Not applicable

Hi,

 

I have a list of codes in a Excel that I want to allocate for each submitted by MS Forms, so only one code per person. 

How would I do this?

 

2019-01-24_08-16-47.png

 

Thanks in advance! 

Has anyone in this thread manage figure out how to implement this properly and if so, could they share it? 

try to delay the schedule every after action.. it worked for me

When a response is submitted

Delay 1m
Get Response Details

Delay 10m

Get a Row

Delay 4m

Post Message to MS Teams
Send an Email

It worked for me finally.

 

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (10,963)