Gather information from Gallery to display on Sharepoint Form

[jcroshaw]

Hello! First time poster.

I have an app which includes a Sharepoint Form with Datacards, and a Gallery. Using the items found in the Gallery, I am calculating an overall "Status" variable based on due dates. This calculates just fine and displays in a label or text input in the App. My end goal is to have the status from the Gallery display on the Sharepoint Form, so that it will also show on my Sharepoint List (I think that is what you call it), which I am using as a Dashboard for my app.

However, I am having a hard time getting the "Status" variable to display in the Sharepoint Form. When I try to do this, I get a "Circular Reference" error. I do not know if there is a better way to gather the "Status" infortion from the gallery so that it will show in the Sharepoint form?

I know this is probably confusing, please let me know what info might be needed to better diagnose or solve this issue.

Thank you!

[v-monli-msft · Accepted solution]

Hi @jcroshaw ,

May I know how did you "calculate an overall "Status" variable based on due dates."? Please share the related formula. 

I assume that Status is a Choice column in SharePoint list. Then you could set the OnSelect property of the icon that you use to navigate to the item in Form control to:

Set(V,TextInput1.Text);Navigate(DetailScreen1, ScreenTransition.None)

TextInput1 is the text control name that you use to input the status in gallery control. DetailScreen1 has the display form control that shows the item detail.

Then in display form, unlock the data card of Status column and set its Default property to:

If(V="Submitted",{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
   Id:1,
  Value:"Submitted"},
V="In Progress",{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id:2,
Value:"In Progress"})

The Id value depends on the order of the values in your Status column.

Regards,

Mona