cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
djg
Frequent Visitor

Error - the given guid doesn't exist in term store

Hi,

 

I am developing a PowerApp for a SharePoint list library. The SP list library has a lot of fields so I have created separate forms in the app for users in different departments to populate their respective data. I get the submit form button on the first form to work but I cant seem to get the submit form button on the other forms to work.

 

Any ideas?

1 ACCEPTED SOLUTION

Accepted Solutions

@djg 

Not necessarily.  You can still use an Edit form, but you need to provide the proper information for the Update property of the DataCard so that it will put the correct information in the MMD column.

The bad part is that (and I haven't looked at this for a while) the support for the term store doesn't really exist in PowerApps, so you need to know the GUID's of the terms you want to use. Although, I've seen some folks work around this to some degree.

If you are using an Edit form, then you need to put a formula similar (obviously filled in with the proper information) to this in your Update property of the DataCard:

{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy",
    'TermGuid': yourGUID,
    'WssId': WssId,
    'Label': Label,
    'Path': Path,
    'Value': Value
  }

If you are going to use a Patch, then you will need a similar formula, but you will also then need to deal with all the other columns in the Patch on your own.

Here is a good article on some of this information and how you can go about it.

 

_____________________________________________________________________________________
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!

View solution in original post

3 REPLIES 3
RandyHayes
Super User
Super User

@djg 

Is one of the columns in your SharePoint list defined as a MetaData Column?

From the error, it sounds like it...in which case, yes, you would need to supply a GUID to the term store item, not a text value.

 

I hope that is helpful or at least gives you something to explore.

_____________________________________________________________________________________
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!
djg
Frequent Visitor


@RandyHayes  yes, I do have a few Managed MetaData columns in the form. @ have done a bit more research and it seams as if I need to be using the Patch function.

 


 

@djg 

Not necessarily.  You can still use an Edit form, but you need to provide the proper information for the Update property of the DataCard so that it will put the correct information in the MMD column.

The bad part is that (and I haven't looked at this for a while) the support for the term store doesn't really exist in PowerApps, so you need to know the GUID's of the terms you want to use. Although, I've seen some folks work around this to some degree.

If you are using an Edit form, then you need to put a formula similar (obviously filled in with the proper information) to this in your Update property of the DataCard:

{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy",
    'TermGuid': yourGUID,
    'WssId': WssId,
    'Label': Label,
    'Path': Path,
    'Value': Value
  }

If you are going to use a Patch, then you will need a similar formula, but you will also then need to deal with all the other columns in the Patch on your own.

Here is a good article on some of this information and how you can go about it.

 

_____________________________________________________________________________________
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!

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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.

Top Solution Authors
Top Kudoed Authors
Users online (2,688)