Yes, an Excel Table object is not greatest place to store data to be manipulated like this, and power users commonly advised against using it for measures like this, but for some older structures of data it's the only means until you have a new system in place.
The trigger condition does not work on document libraries that has content approval set to Yes/activated. The trigger works on the typical document library. Any suggestions?
So you will need to add a trigger condition that checks the Approval Status value before it executes. You can do this if your trigger is a SharePoint one that pulls in the file properties like the "when a file/item created or modified." For example if you want to run the flow only after the document was approved you would add the following condition. @equals(triggerOutputs()?['body/{ModerationStatus}'],'Approved')
Excellent. That has saved me some stress. It only seems to be with the Excel Online CDS that I experience this problem.
Yes, an Excel Table object is not greatest place to store data to be manipulated like this, and power users commonly advised against using it for measures like this, but for some older structures of data it's the only means until you have a new system in place.
Nice video. I created one on the same topic, but you're one is more detailed.
I'll be sure to add your channel name to the description. It's always good to give the viewers an alternative reference. They may follow yours better.
The trigger condition does not work on document libraries that has content approval set to Yes/activated. The trigger works on the typical document library. Any suggestions?
So you will need to add a trigger condition that checks the Approval Status value before it executes. You can do this if your trigger is a SharePoint one that pulls in the file properties like the "when a file/item created or modified." For example if you want to run the flow only after the document was approved you would add the following condition.
@equals(triggerOutputs()?['body/{ModerationStatus}'],'Approved')
@@JohnDayQA thanks, I got this to trigger when owner permissions were given to the service account thats running the workflow.
Thanks a lot. It is wonderful!