I need to export a file periodically with a filtered condition. Each time I export, I need to only export records not exported previously.
I set up an action to execute a sequence of actions: 1. Export File and 2. Mark Records as Exported. I would like to export a file for all records from a table in which [Status]=“Green” AND NOT([Exported]=“Yes”). Once the file is exported, I would then like to set [Exported]=“Yes” for all records with that same condition.
For the “Mark Records as Exported” action, I am having issues completing the “Referenced Rows” logic. I included the following:
but receive the error: The expression is valid, but the result type “Yes/No” is not one of the expected types: List.
I tried using a FILTER statement to identify the records using the following filter statement, but I can’t find a Referenced Action that would allow me to set [Exported]=“Yes” for the filtered records. Is there a better way to do this?
Filter(Tasks, AND([Status]=“Green”, NOT([Exported]=“Yes”)))