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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Chiara Carbone as our Community Spotlight for November…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 647 Super User 2025 Season 2
Tomac 350 Moderator
developerAJ 256
