Upload excel file to sharpoint - empty columns issue/flow

(0) Share

Report

Posted on by dulaa

Hello there,

I got an app & flow that takes data from excel file and updates the SharePoint lists. But sometimes users don’t have all columns filled (due to lack of data at this moment) so they leave them empty. The flow is only uploading the rows with all data (all columns filled). How to modify the flow so that, when the field is empty row should be processed and add anyway. My flow :

Some file (only green ones are uploaded to SP) :

Error msg is :

"The 'inputs.parameters' of workflow operation 'Utwórz_element' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/field_2' is required to be of type 'Number/double'. The runtime value '""' to be converted doesn't have the expected format 'Number/double'.""

I will appreciate any help . Thank You in Advance.

Categories:

Building Power Apps

All responses (1)

Answers (0)

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @dulaa ,

Please try:

if( equals(item()['SAP'],''), 0, float(item()['SAP']) )

or

if( equals(item()['SAP'],'""'), 0, float(item()['SAP']) )

Best Regards,

Bof