I created a flow with a trigger on "SharePoint: When a new document is created".
My idea is to wait for a couple of hours and if the author did not fill-in the mandatory metadata, I would like the flow to send a reminder email in a loop with a delay and a new check until the user complete the metadata.
Here is my flow (sorry for french version):
So, my issue is that after using the "SharePoint: Get file properties" (to get the updated version of the file properties), I try to use them in a debug email but my custom mandatory column is not available. You can see the error message saying that "the property "NumberTest" does not exist" but I was able to select it in the available properties in the flow editor interface.
So, is it because the column is empty or is it a bug? Anyway, even if the column is empty, an empty value should be shown.
Do you know if anybody else had this specific issue? A workaround could be developed with Azure functions and HTTP calls but that would be too complex when a simple action should work for it.
Thank you in advance,
Could you please show a bit more about the "Send an email" action within your flow?
Could you please share a bit more about the custom column ("NumberTest") in your SharePoint library?
Could you please translate the error message into english language?
Further, do you use WDL expression to get the custom mandatory property within the "Send an email" action of your flow?
If you want to use WDL expression to get the custom mandatory property from "Get file properties" action within the "Send an email" action of your flow, please take a try with the following formula (WDL expression):
Note: Do not ignore the ? symbol within your formula.
If you could provide more details about the questions I ask above, I would provide a proper workaround for you.
Not wanting to hijack someone elses thread but I think I'm having the same problem. Which I posted about here:
And I posted in the techcommunity because I cannot add images to my posts on this forum:
I think I know what is happenning but not why. Which is that the 'Get file properties' action (and associated trigger) do not output custom columns which don't have a default value. Unless it is a person/group column. I can work around this by using default values in the columns but this is not my preferred solution.
Perhaps there is way to trap whether a column exists in the output (coalesce?) but I don't know how yet.
I hope this helps somewhat.
In case it helps, I solved my InvalidTemplate error by using coalesce in my Do Until condition. For example:
@and(not(empty(body('Get_file_properties')?['Approver'])),not(equals(coalesce(body('Get_file_properties')?['InvoiceAmountExclGST'], '0'), '0')),not(equals(coalesce(body('Get_file_properties')?['InvoiceDate'], '19000101'), '19000101')),not(equals(coalesce(body('Get_file_properties')?['InvoiceFrom'], 'Nobody'), 'Nobody')),not(equals(coalesce(body('Get_file_properties')?['InvoiceNumber'], '0'), '0')))
Hello @joeyflynn. I'm presuming that you are referring to my flow using the coalesce function. I guess my TechCommunity post was not detailed enough. Its been awhile but I will see if I can find the flow and post here in more detail.
I used ianm's coalesce function to make my required metadata check work and am SO thankful. My document checks are these:
@or(not(equals(coalesce(body('Get_file_properties')?['ApplicantID'], null),null)),not(equals(coalesce(body('Get_file_properties')?['HRDocType']?['Value'],null), null)))
@or(equals(coalesce(body('Get_file_properties')?['ApplicantID'], null),null),equals(coalesce(body('Get_file_properties')?['HRDocType']?['Value'],null), null))
And here is the flow snippet:
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.