Power Platform Community Forum Thread Details

Please see attached screenshot.

Use Case - there are two columns in Excel name as effective date and expiration date .

I need to check if effective date is greater than expiration date .

Set variable expiration date= 10/31/2023.

Need to compare this expiration date to the every effective date present in Excel .

Categories:

Power Automate Desktop

@aggneha9821

Try the below approach:

My excel file looks like below

Flow Screenshot:

Code:

Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Boot\\IInvoice.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance
Excel.ReadFromExcel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData
LOOP FOREACH CurrentItem IN ExcelData
 Text.ConvertTextToDateTime.ToDateTime Text: CurrentItem['Effective Date'] DateTime=> Date_Eff_Val
 Text.ConvertTextToDateTime.ToDateTime Text: CurrentItem['Expire Date'] DateTime=> Date_Expire_Val
 IF Date_Eff_Val > Date_Expire_Val THEN
 Display.ShowMessageDialog.ShowMessage Title: $'''Info''' Message: $'''Effective Date is greater than Expire Date''' Icon: Display.Icon.None Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed
 END
END

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀