You’re offline. This is a read only version of the page.
Announcements
Hi, I'm a total noob, so please bear with me.
I have an Excel table with 4 columns (Week, Office, Category, Count). I'm trying to identify a specific row where the condition for Week, Office, and Category are met. I need to get the value of the Count column to check before I can proceed, inserting new data in Excel. The values to filter for, a user submits via forms.
I tried to use the data array filter operation function, but I'm failing to filter the data results based on the 3 user values. Is there any (easy) way to filter my Excel list and identify a specific row value out of hundreds of data rows?
Thanks
Somehow the same condition is working now if I add it directly to the array filter:
Share
Report
All responses (
Answers (
(
contains(body('Get_response_details')?['re46f446a0a6946bb8186f88e825b87a7'], item()?['Week']),
and(
contains(body('Get_response_details')?['r8069c8b5ec9f45819b56c423a33dcf8c'], item()?['Category']),
equals(body('Get_response_details')?['rcbc31728c8a7492e8a297d843237ac3a'], item()?['Office'])
))
But is this really the best way?
525
