Answered

get row outputs

(0) Share

Report

Posted on by mmacgregor

I am very new to power automate having trouble working something out. I have created a form used by exam markers which records a candidate exam number, which stage of the marking process we are at (where the possible answers to one of the questions is 1st, 2nd or 3rd), and the total candidate score.

Screen Shot 01-08-21 at 11.10 PM 001.PNG

This populates a table in excel like this:

Screen Shot 01-08-21 at 11.10 PM.PNG

I have created a second excel table which has the email address of the three possible markers, John will mark the exam the 1st time, Mary will mark the 2nd time and Peter will mark the 3rd time.

Screen Shot 01-08-21 at 11.09 PM.PNG

I have created a flow which gets all the details from the form, and that works fine.

I am then using 'Get row' (excel) in power automate to find out which marker should mark the 1st, 2nd or 3rd, and it returns 3 outputs (which correspond to a table I have made in excel).

Screen Shot 01-08-21 at 11.11 PM.PNG

What I want to do now is to be able to identify if the correct marker has marked the exam anbd send a message to TEAMS if it is correct..

The code I think I need to create is like this:

outputs('Get_a_row')?['body/1st']

This is where I go prehistoric, I have created three variables to try and replicate the code like this

Screen Shot 01-08-21 at 11.11 PM 001.PNG

Then I join them all together and like this:

Screen Shot 01-08-21 at 11.11 PM 002.PNG

And the resulting string is correct.

The problem is when I then set up a condition like this it doesn't recognise the string MarkingCode variable outputs('Get_a_row')?['body/1st']

Screen Shot 01-08-21 at 11.38 PM.PNG

I am not even sure what I am saying makes sense. I have been at this for hours going round in circles.

I would be sincerely grateful if anyone can assist.

Kind regards,

Martin

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

fchopo 8,003 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello @mmacgregor

The problem is that you are using a variable, which contains a string with the outputs('Get_a_row')?['body/1st'] value. So it is comparing this string, not the value of the expression. I would do something like this:

1) Create a switch condition, using the marking value

2) For each possible value, assign the value to a variable.

3) Do the comparison with that variable.

Hope it helps!

Ferran

Was this reply helpful? Yes No
mmacgregor 5 on at

Like (0)

Report
Copy link

Link copied!

Hi Ferran, thank you for taking the time to get back to me. I'm not 100% sure what to do yet.

When I initialise the variable, what type of variable is it?

And when I Set the variable, what do I need to do in the Value section? Do I add text?

If you have the time then please let me know if you have any ideas.

Moltes gràcies Ferran,
Martin

Was this reply helpful? Yes No
Verified answer

fchopo 8,003 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hello @mmacgregor

As I read in your question, the values in excel cells are string ones, so the variable should be a string type, initialized to nothing (leave it blank).

In the Set variable, in each case element you should assign the value of the column you want to read. In case "1st":

outputs('Get_a_row')?['body/1st']

And in "2nd":

outputs('Get_a_row')?['body/2nd']

Which are the column names in excel.

Hope it helps Martin!

Ferran

PD: Encantat de que parlis català 🙂

Was this reply helpful? Yes No
mmacgregor 5 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much Ferran, I got it working.

All the best 🙂

p.d. Em temo que no parlo bé el català, però m'agradaria. Salutacions des d’Escòcia.

Was this reply helpful? Yes No