Hello,
I'm trying to make a powerapp based on someone filling out a form to get a subscription service for our company. My sharepoint list has calculated columns in it, and it does not resonate with powerapps when I try displaying the data. Does anyone have any solutions?
@Anonymous
You will need to have an edit form to enter the data into the SharePoint list. A display form can be used to show the field in a record. Galleries and data tables are useful to show the data in the entire list and to select the record you wish to work with. Forms are used to edit or display the information in a single record.
thanks! So does the field have to have a gallery? It can't be a display form? And is there a way to only show one column instead of all of them?
@Anonymous
In the screenshot on the left, a calculated value for profit is shown in the bottom. The formula in red is the Default value of the text input box. The gallery shows the Order number for the item selected. In this case, the first item in the gallery is selected.
Hello! Do you think you can do a screenshot of the process? It'll be easier for me to follow along if I have a visual. Thanks for all your help!
@Anonymous
Yep, don't use calculated columns in SharePoint, Stick with number type and do the calculation in PowerApps and save it to the number column.