Power Platform Community Forum Thread Details

I would like to automate the following process in excel using power automate:

1. first, I would like to check if there are empty cells in a certain column

2. then I would like to receive a message or information about a respective cell in another column

(example: cell D4 is empty ==> here is what is written in A4) possibly reusing this output information further as a variable

How can I implement this ?

Categories:

After setting the trigger point and accessing the data from list rows,

Initialize Variable and name it EmptyCellsInfo
Add condition action
In the "Yes" section, users can append to a string variable and pass the value or column—whatever you wish to save. Leave the "No" section as is.
After the "Apply to each", use the information stored in EmptyCellsInfo to send a message or email. You can use actions like "Send an email (V2)" (for Outlook) or similar actions for other messaging services, inserting the EmptyCellsInfo variable in the body to relay which cells were found empty and their associated info.

If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

Thanks!