cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sophiegong
Helper I
Helper I

OneDrive - Excel Get Rows - Create Sharepoint Item

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?

 

222.png11111111.png

2 ACCEPTED SOLUTIONS

Accepted Solutions
grantjenkins
Super User
Super User

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)

 


----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.

View solution in original post

Sophiegong
Helper I
Helper I

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)

 

Sophiegong_1-1669550160297.png

 

View solution in original post

3 REPLIES 3
grantjenkins
Super User
Super User

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)

 


----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.
Sophiegong
Helper I
Helper I

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)

 

Sophiegong_1-1669550160297.png

 

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']

 

 


----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (2,908)