Answered

Condition errors when get items return empty Sharepoint record

(0) Share

Report

Posted on by lechrisvan

Hi,

I'm building a flow getting records from one Sharepoint list (List 1), then use the Title field from List 1 to search for records from another Sharepoint list (List 2). If Title field in List 2 matched, update List 2 data. If it's not, create new record in List 2 with List 1 data. The problem I have is when Get Items return empty records from List 2, it return errors shown in red highlighted.

Flow error 1.png

and I use

Flow error 2.png

Would anyone please share with me your knowledge on how to resolve this issue.

Thank you.

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @lechrisvan

Try to use the coalesce expression where you can default the values for nulls.

Please see this video for how to use Coalesce expression.

https://www.flowjoe.io/2021/04/30/power-automate-functions-coalesce-handle-null-values-from-objects/

Thanks

Was this reply helpful? Yes No
Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report

@lechrisvan Please put you condition out side Apply to each 2. Better use one compose after get items 2 and create length function then use condition and when you will pass ID in update item it will apply loop only to update item action.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
lechrisvan 15 on at

Like (0)

Report

Thank you abm for such quick response.
The issue I have is not Null Field. It's rather empty record return. I tried to use the function empty(body('Get_items_2')?['value']) and it also returns the error. Do you have any other hint?
Thank you.

Was this reply helpful? Yes No
lechrisvan 15 on at

Like (0)

Report

Thank you Hardesh15. I tried your suggestion but it did not work either. A query for List 2 must be executed for each List 1 returned record. It has to validate whether the same record of List 1 exists in List 2.
Any other suggestions?
Thank you.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @lechrisvan

What error are you getting? Could you please post it?

Thanks

Was this reply helpful? Yes No
lechrisvan 15 on at

Like (0)

Report

Hi abm,
This is what i got for the empty record. The error message appears very blur.

Was this reply helpful? Yes No
lechrisvan 15 on at

Like (2)

Report

Thank you both Hardersh15 and abm helping me on this issue. The problem was my looping. It took Hardersh15 suggestion but did not do it properly. I revised my design again and it works as shown.
Thank you.

Was this reply helpful? Yes No