
Hi, I am creating a flow which reads information from an excel sheet and places it inside the diary.
I have most of it working however one last little niggle I cant get my head round.
In this attachment you can see that I am only skipping cells which have been diarised.
However due to the way this document is I need it to ask skip if the excel data contains an invalid selection.
Essentially if the column on the far right is blank then it should skip that whole row?
Is there a way round this?
Hi @NiallOB01 ,
Do you want to add another filter to Filter Query? If so , I'm afraid that is not available , cause only 1 filter function can be applied on a column for list rows.
You could add a 'Filter array' action to filter the table.
Best Regards,
Bof