cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Data from Excel table

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.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User
Super User

Re: Data from Excel table

HI @Mike1962 

 

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

 

 

Screenshot_2020-01-29_at_10_05_37.jpg

 

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

View solution in original post

Highlighted
Community Support
Community Support

Re: Data from Excel table

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.

View solution in original post

7 REPLIES 7
Highlighted
Super User
Super User

Re: Data from Excel table

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:

Screenshot_2020-01-28_at_09_25_13.jpg

 

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:

Screenshot 2020-01-28 at 09.32.41.png

 

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

 

 

Highlighted
Community Support
Community Support

Re: Data from Excel table

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.

Highlighted
Frequent Visitor

Re: Data from Excel table

Hi Manuel.

 

Thank you for your speedy reply!

 

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

 

My FlowMy 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):

 

Screen Shot 2020-01-29 at 05.48.15.png

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.

Highlighted
Super User
Super User

Re: Data from Excel table

HI @Mike1962 

 

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

 

 

Screenshot_2020-01-29_at_10_05_37.jpg

 

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

View solution in original post

Highlighted
Frequent Visitor

Re: Data from Excel table

Hi and thanks for your reply.

 

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

 

Screen Shot 2020-01-29 at 20.57.26.png

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.

Highlighted
Frequent Visitor

Re: Data from Excel table

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

 

Thanks.

Highlighted
Community Support
Community Support

Re: Data from Excel table

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.

View solution in original post

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (11,773)