62
hi All,
I want to use below flow to delete SPL items first then auto create SPL item based on excel list. But for some field "POID",the opition "List row present in a table" have not repopulated by itself. So this column "POID" can't fill in from excel list.I only know the type for "POID" is Number. Any impact for this? Any solution for this issue?
That was only for your POID field of type Number.
You should be able to just use the following expression for your date. If it's not present, then it will default to null.
Share
Report
All responses (
Answers (
items('Apply_to_each')?['Posting Date']
YES!IT works.Thanks a lot!!!
But if the field is date type,it will be some error as below.How to update the expression?
coalesce(items('Apply_to_each')?['Posting Date'], 0)
You can wrap your field into a coalsece expression so that if the field is null, it can default it to 0 instead. The below expression will try to get the value in my Actioned field, but if it's blank, it will return 0.
coalesce(items('Apply_to_each')?['Actioned'], 0)
