You’re offline. This is a read only version of the page.
Announcements
588
I have been given a microsoft form which tracks inductions, which the owner would like to be sent through to a SharePoint list. One of the questions in the form is a declaration along the lines of:
QUESTION: 'I acknowledge that, for the areas I have requested an induction, I am...'
ANSWERS:
- familiar with the fire exits and evacuation procedures
- familiar with the location of relevant fire assembly points
- familiar with the locations of the first aiders and how to contact them
etc.
The idea is that users will tick each box to show acknowledgement.
I would like to check in Power Automate if all the boxes are checked and if so, update the SharePoint List column 'DeclarationSigned' to simply say 'Yes' (rather than update the list with each statement in itself), but I'm really struggling with how I can check if all the boxes are selected. I thought I could do a Condition which reviewed if each statement = true, but I can't seem to pull out each statement individually for them to be checked.
Any help is much appreciated!
@misc Do you have access to the Excel file that is automatically created on the background of this form? This excel online sheet would better serve as a basis for your solution. You can use that Excel sheet to write values to your Sharepoint list. This might be a better solution because the Excel online sheet already has values in right formats and stuff. You can access this Excel file by going to the responses of your form. There will be a button to check the Excel file.
Share
Report
All responses (
Answers (
