Power Platform Community Forum Thread Details

Hi,

I have a situation where my Power app is entering data into SharePoint list using the below query

UpdateContext(
{
overLayText: "Submitting request...",
showOverlay: true
}
);
Set(
OnboardingRequestItemID,
Patch(
SandboxOnboardningRequests,
Defaults(SandboxOnboardningRequests),
{
ApplicationID: OnboardingRequest.ApplicationID,
RequestedBy: OnboardingRequest.RequestedBy,
ApplicationType: OnboardingRequest.ApplicationType,

Confidentiality: OnboardingRequest.Confidentiality,
SOX: OnboardingRequest.SOX,
Integrity: OnboardingRequest.Integrity,

eHLCCDStatus: OnboardingRequest.eHLCCDStatus,
SandboxUsecaseDescription: txtUseCase.Text,
RequestStatus: {Value: "In-Progress"},
GMTGroupEscalationContact: galResultGMTEC & ";" & mailSelectedGMTEC,
GMTGroupDeputies: cmbDeputies_1.SelectedItems,
//Concat(colDeputies,Value,",")
ISXB: true
}
).ID
);
If(
And(
!IsBlankOrError(OnboardingRequestItemID),
OnboardingRequestItemID <> 0
),
Patch(
XYZSandboxQuestionnaire,
Defaults(XYZSandboxQuestionnaire),
{
UsecaseDetails: txtUseCase.Text,
Problem: txtProblem.Text,
BenefitedUserCommunity: txtUerCommunity.Text,
Benefits: txtBenefits.Text,
ModelsUsed: txtModels.Text,
SandboxRequest: {
Id: OnboardingRequestItemID,
Value: Text(OnboardingRequestItemID)
}
}
);
ForAll(
xyz.Attachments As Document,
AddFilesForSandBoxRequest.Run(
Text(OnboardingRequestItemID),
"Requestor",
false,
{
file: {
contentBytes: Document.Value,
name: Text(OnboardingRequestItemID) & "-" & Document.Name
}
}
);
//Notify(Document.Name & "-" & Text(OnboardingRequestItemID) & "attached");
);
ForAll(
xdf.Attachments As Document,
AddFilesForSandBoxRequest.Run(
Text(OnboardingRequestItemID),
"Requestor",
true,
{
file: {
contentBytes: Document.Value,
name: Text(OnboardingRequestItemID) & "-" & Document.Name
}
}
);
//Notify(Text(OnboardingRequestItemID) & "-" & Document.Name & "attached");
);
UpdateContext(
{
ResetControls: true,
RequestSubmitted: true,
OnboardingRequest: Blank(),
error: false,
mailSelectedGMTEC: "",
galResultGMTEC: "",
selectedECEmail: ""
}
);
Reset(txtGMTEC_1);
Reset(attachSBReqDocs_1);
Reset(attachFSAMail);
Set(
objApplication,
Blank()
);
//Set(objViewApplication,Blank());
Refresh(SandboxOnboardningRequests);
Refresh(SandboxRequestAttachments);
Set(
strDefaultFilter,
LookUp(
colStatuses,
Value = "In-Progress"
)
);
UpdateContext({showOverlay: false});
Navigate(
AllRequests,
ScreenTransition.Fade
)
);
Data enters into my SandboxOnboardningRequests Table and using the ID of it it should populate XYZSandboxQuestionnaire and other tables.

But on a few occasions and for few users SandboxOnboardningRequests gets populated but XYZSandboxQuestionnaire doesn't get populated.

i just want to understand what the following reasons could be.
1. is there any problem with my power query above?
2. is it because of the user access? how can i check this or how should check which is the account my power app is using to connect to SharePoint?
3. Do i have to add refresh as well for this table?

Categories:

Building Power Apps

Hi @sujith678

First, please use the </> code snippet 🙂 when you share, trying to read that is not happening.

Second, do they mention any errors?

1. Could be permission but id' expect an error

2. Could be access to the data, but again I'd expect an error

3. Could be based on what they selected or something filtering

I don't think doing a refresh will help, unless you are making Changes to the data and then expect to see it right away. In that case yes so a refresh

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey