cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ryanBourbon
Resolver I
Resolver I

matching tables and updating through email prompts

Hello,

I have been learning and working towards using more automate flows and see a lot of potential but feel past experiences using JavaScript programming has clouded my view as how a process should run, or flow... Puns aside, I have created a process where I would like individuals to submit issues using a form and I pull information from their response into a new sheet with 3 tables.  The first table is their form response.  The second table is who the issue is going to be assigned to based on their response using the send email with options prompt which is automatically sent when the form entry is put into the first table.  The third and final table is for the resolution of the issue and will be based on a prompt within an email as well.  

 

Originally I would have liked to do this with buttons within Excel online (one to assign and one to close) but could not figure out how to format and associate them with script files and I could not find a good prompt option in TypeScript.  My question here is how I would associate the row from the first table that generates the email and places the response in the second table within the same row.  I have a unique ID I am using in table 1 but the flow errored out when I tried to use it.  I will then repeat this process for the resolution portion if this the best method of completion.  Any assistance or suggestions would be greatly appreciated.

 

Thanks,

Ryanfirst response error.JPGfirst response.JPGtables.JPG

1 ACCEPTED SOLUTION

Accepted Solutions

Thanks for the reply, I have tried multiple methods of getting this flow to work using dynamic values but it still does not seem to work.  Maybe it is my thought process as how it should work?  I am treating it like a for loop with an if statement nested inside.  I seem to be able to get update a row but only for one entry.  This method just seems clunky for a process that I feel could be heavily utilized.  

Here is a picture of a flow where I am checking the value in a table and if it is blank (does not contain an x) I want it to grab the row item, and use the information to send an email, then place an x in the column identifying it as complete.  I want to put it right after the send email within the yes condition but it will not perform the action.  If I put it at the end of the flow (outside of all loops) it will run and only place the x in the first entry.  

I am pretty new to this and used to doing similar things with JavaScript.  Any suggestions on better ways of handing this would be appreciated.

 

Thanks,

RyanforLoopAndIf.JPG

View solution in original post

2 REPLIES 2
annajhaveri
Super User
Super User

@ryanBourbon  in the Key Column parameter, you need to provide the name of the column, currently you have number specified.

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

Thanks for the reply, I have tried multiple methods of getting this flow to work using dynamic values but it still does not seem to work.  Maybe it is my thought process as how it should work?  I am treating it like a for loop with an if statement nested inside.  I seem to be able to get update a row but only for one entry.  This method just seems clunky for a process that I feel could be heavily utilized.  

Here is a picture of a flow where I am checking the value in a table and if it is blank (does not contain an x) I want it to grab the row item, and use the information to send an email, then place an x in the column identifying it as complete.  I want to put it right after the send email within the yes condition but it will not perform the action.  If I put it at the end of the flow (outside of all loops) it will run and only place the x in the first entry.  

I am pretty new to this and used to doing similar things with JavaScript.  Any suggestions on better ways of handing this would be appreciated.

 

Thanks,

RyanforLoopAndIf.JPG

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,073)