Answered

OneDrive - Excel Get Rows - Create Sharepoint Item

(0) Share

Report

Posted on by Sophiegong

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?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

grantjenkins 11,063 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
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)

Was this reply helpful? Yes No
Verified answer

Sophiegong 62 on at

Like
a
(0)

Report
Copy link

Link copied!
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)

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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.

items('Apply_to_each')?['Posting Date']

Was this reply helpful? Yes No