Unanswered

Bypass Consent power shell script becomes undone - have to run the SET command again in order for application to work.

(0) Share

Report

Posted on by pullesb

We are having a major issue with a SharePoint list using a customized power apps form. Whenever a user attempts to go into an existing entry off of the SharePoint list, it asks for the "Allow" connections every time (not just once). It also does not even bring up the list item in display mode, rather acts as if it is a new record. If they back out, click on the list item again, then it goes in correctly. Very inconsistent.

However, once we run the Set -AdminPowerAppApisToBypassConsent powershell script, it seems to fix this issue. But then, for some unknown reason, this setting becomes "undone" (false) instead of "true".

They have "edit" access to the list and with one user, we even gave them full control.

This is on an application we just built and went live with on Monday. At least 2 other applications that are new (not yet live) have this exact same issue!

I would love to go back to writing true Power Apps (using the SharePoint list as a source vs customized forms), but that has the 2000 record limit for the search function.

Thanks for any help you can provide!!!!!!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

TheRobRush 11,128 Moderator on at

Like (0)

Report
I hear you! Building PowerApps, for me, is so much better than custom forms.

I would recommend trying this

Build a flow that has a get items and set it up like so

the example list in my photo has about 5k items currently and California Creative is part of the name of a record located in the first 100 records created, running this flow returns the correct result even with 5k items in the list.

you could send a search term from powerapps to flow, and then return the resulting records back to powerapps via the same flow.

replacing the search term California Creative with Test Me returns the last 3 items added to the list, which I just place din now as a test.

Syntax is

substringof('Test Me', SchoolName)

where Test me is your search term and SchoolName is the column to search

Was this reply helpful? Yes No
pullesb 40 on at

Like (0)

Report

I'm not sure how a power automate flow has to do with my issue of a customized form using power apps off a Sharepoint list??

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report

You said, in your final statement, youd prefer building actual PowerApps again but cannot do it with the 2k limit for using search... Do what I showed you above and you can bypass the limit using search via flow.

Was this reply helpful? Yes No
pullesb 40 on at

Like (0)

Report

Ah - gotcha! Thanks!

Was this reply helpful? Yes No