Answered

Error When Update Sharepoint List using power automate

(0) Share

Report

Posted on by wachid

i am trying to update sharepoint list base on my excel data. but if my column value is blank, flow not running (error). please help me how to fixed it.

excel to ms list.png

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

doschtert 38 on at

Like (0)

Report
Copy link

Link copied!

Hi @wachid,

have you checked in your Sharepoint List whether the column Received requires value? If yes, then uncheck it. 😊

Was this reply helpful? Yes No
wachid on at

Like (0)

Report
Copy link

Link copied!

i have unchecked it, and the result is same, still error.

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @wachid

You need to set the column value to null when excel column is empty or blank. You need to write an expression to work it:

if(empty(items('Apply_to_each')?['Received']),null,items('Apply_to_each')?['Received'])

I have assumed that you are creating an item in a loop 'Apply to each'.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
wachid on at

Like (0)

Report
Copy link

Link copied!

can you share your screenshoot?

Was this reply helpful? Yes No
Verified answer

Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @wachid

Here you go, it's an example of setting title column:

if(empty(items('Apply_to_each')?['Received']),null,items('Apply_to_each')?['Received'])

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No