Announcements
Dear all,
How to check if an Array contains values in excel?
I use the Condition ,entering the output of the Filter Array and entering the filed in Excel.But it doesn't work
Hi GUOGUO,
You have an array. right?
Before adding the value to an excel you need to check whether it exists in excel or not. Is this what you are looking for?
If Yes, then You can use below:
If the action returns a row or rows this means the record exists
if the action does not return a value that means the record does not exist.
To check the existence of a record. You need to use condition control after the list or get.
If I answer your question then please mark it as verified.
Let me know if I can provide you with more details.
ThanksRegards,
Abdul WahabPower Platform/Customer Engagement Developer/Lead/Solution Architecture/Project ManagerDirect/WhatsApp:+923323281237E-mail: abdulwahabubit@outlook.comSkype: abdul.wahabubitLinkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a
For more details read the link.
Hi AbdulWahab,
Thanks for your feedback.
Actually,i want to use Condition to check if the values in Excel is in the Array.
then Use the filter array action. For more details, read it out: Use data operations in Power Automate (contains video) - Power Automate | Microsoft Docs
Abdul WahabPower Platform/Customer Engagement Developer/Lead/Solution Architecture/Project ManagerDirect/WhatsApp:+923323281237E-mail: abdulwahabubit@outlook.comSkype: abdul.wahabubitLinkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 315 Super User 2026 Season 2
Mohsin Ali 267
Henil 115