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,
then Use the filter array action. For more details, read it out: Use data operations in Power Automate (contains video) - Power Automate | Microsoft Docs
If I answer your question then please mark it as verified.
Let me know if I can provide you with more details.
Thanks
Regards,
Abdul Wahab
Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
Direct/WhatsApp:+923323281237
E-mail: abdulwahabubit@outlook.com
Skype: abdul.wahabubit
Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/
Hi AbdulWahab,
Thanks for your feedback.
Actually,i want to use Condition to check if the values in Excel is in the Array.
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.
Thanks
Regards,
Abdul Wahab
Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
Direct/WhatsApp:+923323281237
E-mail: abdulwahabubit@outlook.com
Skype: abdul.wahabubit
Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a
For more details read the link.