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

Gather information from Gallery to display on Sharepoint Form

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!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-monli-msft
Community Support
Community Support

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

 

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
jcroshaw
New Member

 
v-monli-msft
Community Support
Community Support

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

 

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,164)