Answered

Gallery & View Form - 2 Fields from Sharepoint not displaying in Power App

(0) Share

Report

Posted on by Previsible

Hi there,

I have a powerapp that I connect to sharepoint, all of the fields aside from 2 do not display in the app and I get the error "This Formula Uses Scope which is not currently supported for evaluation."

I only get this for 2 of the fields:

"Title" which is a Single Line Text item

and
"Reviewer" which is a Person or Group entry

I have 0 formula errors at the moment to base this on

Does anyone know how I would going about beginning to figure out why these 2 fields will not propagate?

Categories:

Connectors

Connecting to Data

General Questions

I have the same question (0)

All responses (10)

Answers (1)

WarrenBelz 150,376 Most Valuable Professional on at

Like (0)

Report

Gallery & View Form - 2 Fields from Sharepoint not displaying in Power App

Hi @Previsible,

Good that you for it working. Person fields are a complex field type and to Update or Patch, you need to send all the correct field elements (the five I listed) and then the correct references to them.

The Combo Box output also has three possibilities depending on the Items used.

If you use Choices(ListName.PersonFieldName) , the output is DisplayName and Email. Note here the choices will be restricted to the people already saved in the list - it does not query the Azure directory. If you use this, the Update can be ComboBoxName.Selected, but using the code I supplied is more specific.

If you use Office365Users.SearchUserV2(. . .) searching all users, the output is DisplayName and Mail

You can also use Office365Groups.ListGroupMembers(. . .) searching a particular Group and the output is displayName and mail (which is what you had in one of your posts).

Was this reply helpful? Yes No
Previsible 70 on at

Like (0)

Report
Gallery & View Form - 2 Fields from Sharepoint not displaying in Power App

@WarrenBelz

You were 100 percent right with everything, I couldn't seem to get the DataCards to reference a person no matter what I changed so I just made a whole new form, ensured I included the code
In the the Update
{ Claims: "i:0#.f|membership|" & Lower(DataCardValue2.Selected.Email), Department: "", DisplayName: DataCardValue2.Selected.DisplayName, Email: DataCardValue2.Selected.Email, JobTitle: "", Picture: "" }

and the DefaultSelectedItems

{ DisplayName: ThisItem.Reviewer.DisplayName, Email: ThisItem.Reviewer.Email }

And now everything is working as intended and expected. Thank you for your time and patience.

Was this reply helpful? Yes No
Previsible 70 on at

Like (0)

Report

Gallery & View Form - 2 Fields from Sharepoint not displaying in Power App

@WarrenBelz I don't know if I have an adequate answer to that, I didn't think I had intentionally chosen to reference group or person: I copied what you had showed me and removed the one field I was aware I wasn't using (Claims if i leave it in there's an error). The list item in sharepoint is set to person or group. Both DataCards are dependent on displayName and I have loaded the data for the groups SiteMembers collection into the app as well.

Would it benefit me to maybe just start over and rebuild the form from scratch? Perhaps my playing around and changing things has broken the sharepoint connections, or I have just made mistakes which might be corrected by starting over...

Was this reply helpful? Yes No
WarrenBelz 150,376 Most Valuable Professional on at

Like (1)

Report
Gallery & View Form - 2 Fields from Sharepoint not displaying in Power App

@Previsible,

You have left out the Claims field - also why are you using displayName and mail if your Items are
Filter( Choices([@Deskside QA'].Reviewer, DisplayName = DataCardValue23.Selected.DisplayName )

The output of this should be DisplayName and Email. Sounds to me that you are using a Group member search in the Items.

Was this reply helpful? Yes No
Previsible 70 on at

Like (0)

Report

Gallery & View Form - 2 Fields from Sharepoint not displaying in Power App

@WarrenBelz

I followed this ensuring all of the fields were accurate to no avail

I had to remove the Claims line as I do not have that field used in the app.

I don't see an error in the Live Monitor, and it allows me to submit the form and it looks like all of the fields I selected are propagating as expected (I think)

Was this reply helpful? Yes No
Verified answer

WarrenBelz 150,376 Most Valuable Professional on at

Like (1)

Report
Gallery & View Form - 2 Fields from Sharepoint not displaying in Power App

@Previsible,

In the the Update of the Data Card (I assume the Combo Box is DataCardValue2 and is not multiple selection)
{ Claims: "i:0#.f|membership|" & Lower(DataCardValue2.Selected.Email), Department: "", DisplayName: DataCardValue2.Selected.DisplayName, Email: DataCardValue2.Selected.Email, JobTitle: "", Picture: "" }

and the DefaultSelectedItems

{ DisplayName: ThisItem.Reviewer.DisplayName, Email: ThisItem.Reviewer.Email }

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Previsible 70 on at

Like (0)

Report

Gallery & View Form - 2 Fields from Sharepoint not displaying in Power App

@WarrenBelz ahh the brackets DID IN FACT repair the issue I had where the Title wasn't displaying on the Gallery so now the title does in-fact appear in the gallery.

I managed to get the Title card on the Form update the sharepoint list by deleting the field, updating the sharepoint data, then, re-adding the field.

I did this with all of the fields that were not updating the sharepoint list from a suggestion I found online saying that sometimes a field can be broken in power apps when the list item is updated in sharepoint.

I still can't seem to get the Person or Group item to update to the sharepoint.

Was this reply helpful? Yes No
WarrenBelz 150,376 Most Valuable Professional on at

Like (1)

Report

Gallery & View Form - 2 Fields from Sharepoint not displaying in Power App

Hi @Previsible,

Firstly, that formula you have in the DataSource of the Form should be in the Item and the DataSource should be the List name. You also need to remove the brackets from the Ticket label in the gallery.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Previsible 70 on at

Like (0)

Report

Gallery & View Form - 2 Fields from Sharepoint not displaying in Power App

@WarrenBelz sorry, I am novice and I'm not explaining myself well:

This is a display form which loads from a Gallery item when they click the gallery item it navigates to the Display Form Screen based on the Parent Item (which is the Title)

When I went to double check my data source I found the gallery and display are accurate, because the form is not submitting the Reviewer or Title card and I don't know why:

When I look at my data cards they look to be correct

Was this reply helpful? Yes No
WarrenBelz 150,376 Most Valuable Professional on at

Like (1)

Report

Gallery & View Form - 2 Fields from Sharepoint not displaying in Power App

Hi @Previsible,

There is more information required here to understand what you are trying to do. Firstly, you can disregard that message This Formula Uses Scope which is not currently supported for evaluation if the function works as required.

What type of controls are you using those formulas on and what property of the controls and you applying them to ? Also are they in a Form or Gallery or simply on the screen ?

Also briefly, what are you trying to achieve here ?

Was this reply helpful? Yes No