How to load multiple excel then apply expire date check?

Like (0) Share

Report

Posted on 22 Jun 2022 05:23:18 by hankycheng0621

Hi all

I want to use Power Automate to build a contract expiration date alert. I have over 30 nos Excel with same format and table setting on OneDrive but no idea how to load multiple excel with the date checking process (I don't want to click 30 times "List rows present in a table ^_^"). Anyone can help? Tks

All responses (6)

Answers (0)

Riyaz_riz11 2,686 Super User 2025 Season 1 on 27 Jun 2022 at 11:25:31

Like (0)

Report

Re: How to load multiple excel then apply expire date check?

Hi @hankycheng0621 ,

It will fail because you are passing some other file format instead of xlsx
hankycheng0621 39 on 26 Jun 2022 at 02:07:53

Like (0)

Report

Re: How to load multiple excel then apply expire date check?

Flow

Error
hankycheng0621 39 on 25 Jun 2022 at 12:53:36

Like (0)

Report

Re: How to load multiple excel then apply expire date check?

@Ahammad_Riyaz Still the same error. No idea what I'm wrong
Riyaz_riz11 2,686 Super User 2025 Season 1 on 23 Jun 2022 at 05:39:30

Like (0)

Report

Re: How to load multiple excel then apply expire date check?

Hi @hankycheng0621 ,

It was not a issue, if that file is not having table it will not move further steps, if file is having table it will move to further steps check with click on next.

It will work Just handle exception

Here in that condition three dots click there we have configure run after action is present

This is exception handling.

And that folder should contain only excel files.

Regards

Ahammad Riyaz

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
hankycheng0621 39 on 23 Jun 2022 at 01:10:30

Like (0)

Report

Re: How to load multiple excel then apply expire date check?

Tks @Ahammad_Riyaz , i try it but fail. Error message is 'Could not obtain a WAC access token.'. I checked Excel REST API supports only Office Open XML file formatted workbooks. The .xls extension workbooks are not supported.
Riyaz_riz11 2,686 Super User 2025 Season 1 on 22 Jun 2022 at 07:01:35

Like (0)

Report

Re: How to load multiple excel then apply expire date check?

Hi @hankycheng0621,

First you have to display list files in folder, after you have to get tables so it will get the file properties, this will work if the file is created as a table format excel.

Please refer the screenshots.

and every action u have to pass inside apply to each from filter array to send email.

Regards

Ahammad Riyaz

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.