Data from Excel table

[Mike1962]

Hi. I am a relative novice with extracting data from excel tables. I am trying to set up automatic emails to notify when a staff members significant birthday (20, 30, 40, 50, 60) approaches.

I can get the raw data from the table using ‘get rows’ but can’t figure out how to extract the matching data using ‘conditions’. I think I may have to create a ‘variable array’ to hold the ‘get rows’ data but can’t then work out what to do next!

I have a calculated column in the excel table that tells me the age in months so I can see a month before the significant birthday approaches. This is the column/value I want to filter by and return the staff details to be added to the automatic emails.

Can anyone guide me please

Thanks.

[manuelstgomes]

Hi @Mike1962 

No need to create an array. Get items to return one in the "values" that you can use to cycle through the data. Here's an example:

You can even calculate the significant birthdays with the following formula:

mod(items('Apply_to_each')?['calculated'],10)

If anything divided by 10 gives a remainder 0 it means that it's a significant birthday.

Then you can use it as so:

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
​
Cheers
Manuel

[v-alzhan-msft]

Hi @Mike1962 ,

Please take a try with @manuelstgomes 's solution and let me know if your problem could be solved.

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mike1962]

Hi Manuel.

Thank you for your speedy reply!

So, based on your advice here is my amended flow:

My Flow

When i run the flow i get the data from the Get Rows stage and I can see that in the outputs of this stage.

However, I am getting a False result in the Condition input (see below):

So to me it looks like the condition is not finding any records with 479 in the Age in Months column from the spreadsheet? But there is one record with 479! Is this something to do with the data type needing to be converted to integer or something like that? 

Hope you can help.

Thanks,

Mike.

[manuelstgomes · Accepted solution]

HI @Mike1962 

It could be the data type. Just use the same value on the left side and enclose it in an int() function.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
​
Cheers
Manuel

[Mike1962]

Hi and thanks for your reply.

When I use the int() function the list of dynamic content reduces to two:

As you can see the column headings from my spreadsheet are not in this list so cant put anything in.

Any other ideas please?

Thanks.

[Mike1962]

Hi. Please see my subsequent posts - can you help please?

Thanks.

[v-alzhan-msft · Accepted solution]

Hi @Mike1962 ,

You could add a Compose action before the condition and save the value to the Compose, then you could use the expression for the Compose in the Condition.

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.