web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Checking if record is ...

Power Automate

Answered

Checking if record is in Sharepoint list, Export data from other list if not

(0) Share

Report

Report

Posted on by IR_06

23

Hi all,

I am currently working on report for employee absence app.

I want to use Power automate to export list of employees that haven't had any absences.

All data is stored in SharePoint lists.

Absences fields:

*From

*To

*Days

*Employee ID

Employees fields:

*Employee ID

*First name

*Surname

*Department

Report information needed:

*Employee Id

*First name

*Surname

*Department

This is where I am currently on Power Automate:

This solutions doesn't work as it still shows all employees

Hope someone have some kind of solution for this.

Thanks

Categories:

All responses Img

All responses (6)

Answers Img

Answers (1)

Sort by

Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @IR_06 ,

Please check if dynamic content in current flow is same as following.

Then add a condition before "Add a row into a table".

empty(body('Filter_array'))

Best regards,

Rimmon
IR_06 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Just tried this but nothing has been added to file. Flow is running but no matches have been found
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @IR_06 ,

Could you please show your current flow?

In addition, what is the type of Employee ID?

Best regards,

Rimmon
IR_06 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Employee Id is text
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @IR_06 ,

It should be "is equal to".

Best regards,

Rimmon
IR_06 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, that seems to be working. Thank you a lot 👍

Join the conversation