cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aspatank
New Member

expected output not visible in powerapps form

I have a 'view selection' datacard in my powerapps form which is a lookup value from a sharepoint list.
The 'PO-number-x:PO-year-end-provision' looks up the po number in the list and gives the matching value for the year-end provision.
When the form is filled, the data is updated in the sharepoint list but not displayed in the form, as it should be displayed automatically when i put in the po number.
attaching the needed screenshots, would be grateful if somenody could help me. 

 

13 REPLIES 13
poweractivate
Community Champion
Community Champion

@aspatank 

 

Check in case that the following helps:

 

1) If the form DefaultMode or current form mode is set to FormMode.New it will not be intended for displaying an existing record, even if the Item property of the Form is populated, all values will be blank. Try to change the DefaultMode to FormMode.Edit or FormMode.View. Or to change this from runtime use the EditForm or ViewForm functions  from somewhere in the app such as OnSelect of the button and after the SubmitForm.

 

2) In case #1 did not help above, check about what way are you submitting the form? Are you using SubmitForm or Patch? 

 

3) In case the change is being made from another user that is using the app on different device, change may not automatically show on the other user or device's App - to achieve this, you may need to use Refresh function on the data source, from somewhere in the App, such as from an auto-repeating timer OnTimerEnd to capture changes made by other devices or users concurrently and to automatically update the form that way.

 

Check if above helps @aspatank 

 

 

RandyHayes
Super User III
Super User III

@aspatank 

The one screenshot you did not provide was your DefaultSelectedItems property of your DataCardValue3 combobox control.

Since it is based on a Choices function, make sure that your DefaultSelectedItems property of the control is set to : 

  Parent.Default

I am assuming that your datacard in your EditForm is based on the PO number column that you indicated and that it is a Choice column (also that it is a single choice column and not a multi-choice/checkbox column).

 

If that does not work and any of the assumptions above are not correct, please clarify.

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Hello,

The form is already set to FormMode.Edit. 

I am submitting the form using SubmitForm.

I have also tried refreshing the data, but that doesnt work too.

Not sure what's the problem here.

 

Thanks.

Hi Randy,

The DefaultSelectItems property is already set to Parent.Default.

Also, you are right about the po-number column, it is a dropdown value (single-choice) and looks up the value in a sharepoint list.

Thanks.

RandyHayes
Super User III
Super User III

@aspatank 

Very good.  Yes, there is no need to Refresh the datasource as you are writing the values in your app.

So, my question is...are you certain that the value you are writing from the ComboBox is being written to the datasource?  

Check the following:

1) The Default property of your DataCard should be set to: ThisItem.PO_x002d_number_x002d_x_x003a_PO4 (or its friendlier name)

2) The DefaultSelectedItems property of your DataCardValue3 combobox should be Parent.Default (you've verified this - thank you)

3) The Update Property of your DataCard should be : DataCardValue3.SelectedItems

4) The Items property of your DataCard should be : Choices([@'PO-Invoices_2'].PO_x002d_number_x002d_x_x003a_PO4) (which you have also verified).

 

Please verify all of the above and clarify that all is as expected, or change accordingly.

 

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Hi Randy,

I'm getting an error when I do the changes.

 

RandyHayes
Super User III
Super User III

@aspatank 

Sorry...forgot that it was single select choice column...

Change that formula to DataCardValue3.Selected

The second picture is not an error, that is just normal with the Formula Editor.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Hey Randy, 

I made all the changes as you suggested, still no luck.

The value is again getting updated in the list, but not in the form when I put in the PO-number.

 

RandyHayes
Super User III
Super User III

@aspatank 

I'm about to call it a night here, but put together some screenshots of your Column definition in SharePoint (list settings -> click on column to edit).  A screenshot of the combobox items property, and defautselecteitems property. And a screenshot of the Default and Update property of the Datacard.

I will take a look at them first thing in the morning (here).

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,435)