cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PavelBaranov
Regular Visitor

Filter and update Excel Row

Dear friends, I have very simple task to automate.

 

There is an excel file which is shared on OneDrive (Teams). Please notice that this file contains table with hidden columns (as I understand ODATA filtering is not working with hidden columns).

 

This Excel file contains rows which are completed by my staff. I wish Power Automate checks every hour rows for which Sendmail cell is empty & AIS Record Id. is not empty. For that rows I wish to create HTML table and submit this table by email to my staff.  In order to prevent duplicate emails I wish Power Automate to update Sendmail cells for items submitted to email to my staff. 

 

My current flow is the following:

 

1. Recurrence Step

2. List rows in a table

 

Step 1.PNG

 

3. Select specific data from table

4. Filter selected data (I need to take rows which contains the following: Senmail cell is not empty and AIS Record Id. cell is not empty)

Step 2.PNG

 

5. Check if the filtered array is not empty.

6. If the filtered array is empty - then terminate the flow.

7. If the filtered array is not empty - then create HTML Table and Send an email

 

Step 3.PNG

 

The problem is that I don't know how to update rows in excel file for items were submitted to my staff.

Please notice that my Excel table has a unique row identifier for each row specified in column called LBR ID.

 

Thank you for help.

1 REPLY 1
yashag2255
Dual Super User II
Dual Super User II

Hey @PavelBaranov 

 

You can then add an apply to each action that takes the values from the excel list rows action. now, in this, add another apply to each for the filtered array output and then in the second loop check for a unique identifier on the current item in the excel and this filtered array and if they are same add an update row action and if not, just leave the no branch as is. 

 

You will have to remove the terminate action from the no branch of the previous condition for this to work. (as the flow will any way do nothing if the condition is not met and the branch is left empty)

 

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!

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (46,636)