Flow pulling dates from excel

[Anonymous]

Hello Flow Family,excel, Flow

I'm having trouble creating my flow. What it's supposed to do is pull dates from a column and if the date 11 months old then it should send an email to me saying I need to update it. What I have so far is the "get a row" and I put in the excel doc that is on sharepoint and put in all the information. When I get to "Key Column" I put in "Last Back Ground Check" and then when I try to put in key value, I can't put in any dynamic content. All it will let me put in is the "manually trigger a flow" options, instead of the dates. Where do I go from here

Thanks in advanced 

[yashag2255]

Hi @Anonymous 

Can you please share a screenshot of your flow? Pulling a date item from excel might give you some junk values due to the datatype formatting of the column in excel. Also, you can always use the expression editor in such cases. 

But let us first know the datatype of the column you are trying to compare with so that wwe can assist you better with this. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[v-yamao-msft]

Hi @Anonymous ,

Could you share more details on your flow for better understanding?

If possible, please share a screenshot on your flow as well.

Per my understanding, the Excel table is stored in SharePoint library, and you want to get rows from the table, send out an email if the date is 11 months old.

Instead of using Get a row action, I suggest use List rows present in a table to get all the rows, using functions to filter out items that dates are 11 months old.

I have set up the flow likes below for your reference.

After the manual trigger, list rows present in a table.

Add a Condition with the following code to check if the dates are 11 months old:

formatdatetime(addDays('1899-12-30',int(items('Apply_to_each')?['Start'])),'MM')

is equal to

getPastTime(11,'Month','MM')

Under if yes branch, send out a notification.

Best regards,

Mabel

[Anonymous]

So here's where I am now per your advice. I'm a little confused but think you understand what I want. So I pulled the table I want but how do I ensure that it pulls the dates from the column that I want and then sends an email with that rows corresponding vendor saying we need to update this specific vendor because this date is expired

[yashag2255]

Hi @Anonymous 

You have to ensure that the date column that you are bringing in is properly formatted. I suggest, change the datatype of the column to Text in your excel sheet. Pull it in flow and then use the formatDatetime function to properly format it and then use it in the email.

Hope this Helps!

[v-yamao-msft · Accepted solution]

Hi @Anonymous ,

I suppose that you have corresponding columns in the Excel table, such as Date, Vendor, etc. so after the action List rows present in a table, you will get a list of dynamic contents for the table.

Then you could use the dynamic contents in your functions.

Under if yes branch of action Send an email, just select the dynamic content Vendor, if it contains an email address, an email will be sent out for rows which meet the condition.

Best regards,

Mabel