Share
Report
16Hey Everyone,
I am facing a situation :
I have created a power apps which works as a survey form and on start of the app I create a collection and Add column from my SharePoint Questions and AddColumns of my own:
OnStart Code:
Refresh(SPSurveryQues3);
ClearCollect(
ResponsesColl,
AddColumns(
ShowColumns(
SPSurveryQues3,
"Title",
"Question",
"QuestionRefNo",
"Domain",
"ProgType",
"Index"
),
"QResponse",
"a",
"QUser",
User().Email,
"Data",
""
)
);
Set(
varCurrentIndex,
1
);
Set(
varTotalRecords,
CountRows(ResponsesColl)
);
AT THIS STAGE AFTER CLICKING ON SUBMIT I EXPECT THE APP TO RENDER SCREEN 2 BACK FOR ME BUT THE SCREEN GOES WHITE:
My Gallery Items Code is:
LookUp(ResponsesColl, Index = varCurrentIndex)
This is the code for every button on select:
Patch(
ResponsesColl,
LookUp(
ResponsesColl,
QuestionRefNo = ThisItem.QuestionRefNo
),
{QResponse: Button2_6.Text}
);
If(
varCurrentIndex = varTotalRecords,
Navigate(Screen3)
);
If
(
varCurrentIndex <= varTotalRecords,
Set(
varCurrentIndex,
varCurrentIndex + 1
)
);
When the last Question button is pressed and answered the program will redirect to he submit page:
UpdateContext({
MaxResponseID: Max(SPSurveyAns2, 'SurveyID (ResponseID)')
});
ForAll(
ResponsesColl,
Patch(
SPSurveyAns2,
Defaults(SPSurveyAns2),
{
Title: Question,
QuestionRefNo: QuestionRefNo,
ProgType: ProgType,
Response: QResponse,
'SurveyID (ResponseID)': MaxResponseID + 1
}
)
);
Clear(ResponsesColl);
Navigate(Screen2);
Refresh(SPSurveryQues3);
Notify("Your Response was submitted successfully! You are amazing");
AT THIS STAGE AFTER CLICKING ON SUBMIT I EXPECT THE APP TO RENDER SCREEN 2 BACK FOR ME BUT THE SCREEN GOES WHITE:
Then I need to refresh the chrome page to get my app screen 2 Again.
I there any way I could automate that refresh?
Categories:
I have the same question (0)
All responses (
Answers (
