Sharepoint choice column returning blank text - entry data is from Power Apps combo box

(1) Share

Report

Posted on by CU18031345-0

Hi all! Firstly i have created a Power App where users submit their entries, this is the update value for the combo box {Value: If(IsBlank(DataCardValue39.Selected.Value), DataCardValue39.SearchText, DataCardValue39.Selected.Value)}. Users can select a value from dropdown, or write their own answer or leave it blank because this field is not required to be filled out.
This data goes into Sharepoint where we have Product Names, its a choice column where users can add their own text, so its kinda like a combo box as well. No need for unique values.

After this i have created a Flow where after every new item is submitted users receive an email confirmation. Everything works but the Product Name is blank. I used both dynamic expressions
triggerBody()?['Product_x0020__x0020_Name']
triggerBody()?['Product_x0020__x0020_Name/Value']

and its always blank. It worked before the issue started recently. Any ideas where the problem is? is it in the dynamic expressions or the power apps update field?

Many thanks!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Michael E. Gernaey 53,974 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @CU18031345-0

Please try not to write a paragraph of words to describe your problem its really really hard on us to just read long descriptions an visualize what you can see.

Please use pictures and video and a business process overview of what you are needing to do all up, then tell us which steps you need technical help with, and we are happy to help.

Cheers,

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 6,422 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@CU18031345-0,

Update your Combo Box Update property to support both selected and custom input properly as shown below.

If( !IsBlank(DataCardValue39.Selected.Value), { Value: DataCardValue39.Selected.Value }, If( !IsBlank(DataCardValue39.SearchText), { Value: DataCardValue39.SearchText }, Blank() ) )

Once the Power App sends the value correctly, your Flow expression should work with

triggerOutputs()?['body/Product_x0020__x0020_Name/Value']

Or, if it’s flat text (fill-in value only)

triggerOutputs()?['body/Product_x0020__x0020_Name']

Check and revert me back accordingly.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item

Was this reply helpful? Yes No