Unanswered

PowerApp to PowerAutomate - sending null value to PowerApps

(0) Share

Report

Posted on by MariaK5

HI All, successfully integrated my powerapp with power automate. This power automate now runs when the user updates a record, in additional to updating the edited record in sharepoint list A, it also updates 2 fields in sharpeoint list B.

The key between the two lists is Asset ID - no issue there.

The second value is sharepoint list A's list ID into related field in sharepoint list B - no issue there.

The third value is a string value. This value can be null, this is where the issue is. This value is updated in sharepoint list B only when it's not null. When it's null, it throws an error. The flow is not expecting a null for the variable.

How can I adjust this so that a null value will be accepted by the flow? The field in shareoint list B is not required and null is a valid value. Not sure if i need to fix in before triggering the flow or handle it in the flow itself.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

naono 33 on at

Like (0)

Report
Copy link

Link copied!

How about using the empty function to determine if it's null?
Or how about scoping the error and ignoring it?

This is an article in Japanese, but I'll paste the reference URL. Please do your best.
MicrosoftFlowでの空白判定のやり方 | ～UNRULY～気ままなブログ (lawless098.com)
Power Automateの例外処理は「スコープ」で行う | 仕事のあれこれ (ippu-biz.com)

Was this reply helpful? Yes No
MariaK5 33 on at

Like (1)

Report
Copy link

Link copied!

I know the value is null, how do you scope the error and ignore it?
Think link is in japanese, sorry not one of my languages LOL. Any further help appreciated.

Was this reply helpful? Yes No
naono 33 on at

Like (0)

Report
Copy link

Link copied!

Power Automate has a scope connector. You can use it like Try-Catch-Filnally.

As you may know, Try-Catch-Filnally is explained as follows. The place where the error may occur is enclosed in Try, and the processing when the error occurs there is written in Catch. Then, the process to be done whether an error occurs or not is written in Finally.

I'm sorry that this is also a Japanese article, but I'll paste the reference URL.

Power Automate 「スコープ(コントロール)」アクション | 誰でもできる業務改善講座 (sekenkodqx.jp)

Was this reply helpful? Yes No
MariaK5 33 on at

Like (0)

Report
Copy link

Link copied!

Still need help. I don't know c either. Need simple solution for flow to be able to process a null.

Was this reply helpful? Yes No
MariaK5 33 on at

Like (1)

Report
Copy link

Link copied!

actually found a way to do this. not ideal, but i will save a dummy value then run another flow to wipe out the dummy values after they are saved.

Was this reply helpful? Yes No
naono 33 on at

Like (0)

Report
Copy link

Link copied!

Sorry I can't be of any help.
I tried to register an empty variable in the list, but I couldn't reproduce the same phenomenon.
Maybe I am not understanding what kind of flow you are creating.

The following article describes how to check for Null in Power Automate. Isn't it helpful?
Solved: Check Field Value Null - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
Heartholme 1,278 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Try this:

https://powerpostal365.com/2023/10/04/how-to-handle-null-data-when-passing-json-objects-from-flow-to-powerapps/

✔ Marking my post as a solution not only confirms that your question has been answered, but also helps others find solutions to similar problems.
By doing so, you'll be making a valuable contribution to the community.

Best Regards
Heartholme

Was this reply helpful? Yes No