cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper V
Helper V

Accessing data in an Excel table

I am trying to access data in an Excel table to use in several ways to complete an audit made by several people regarding several other people; one form per audit, several audits to be made by each auditor. If function, this is much like a survey.

 

In a pre-populated table in Excel, there will be:

1. Email addresses

2. Unique data to be populated into the audit form, specifying who is being audited

3. Columns to hold the responses to the audit questions

 

The workflow: (I am not married to this)

1. Auditors receive an email with a link to the form.

2. The form contains:

   a. The ID of the person being audited

   b. The email address of the auditor

   c. The questions being asked

   d. the allowable answers for each question (all are required)

3. The the form is submitted, the answers are in the same row with the ID of the person being audited.

 

I had not thought this would be Forum-worthy, but I'm having trouble finding a course or doc or video to help me. 

I REALLY appreciate your help.

1 ACCEPTED SOLUTION

Accepted Solutions

Hi again!

No, you are reading right, it was me that misunderstood your requirements.

So you are looking for a way to distribute a form, and some of the responses should be already filled in (and not editable by end user)...

I would discard Microsoft Forms and explore an alternate form interface based on a either PowerApps or Adaptive Cards

Nice challenge you got in mind... Happy Flowing!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

4 REPLIES 4
Super User III
Super User III

Hi!

Did you consider this approach?

https://flow.microsoft.com/en-us/galleries/public/templates/a8fe18d6de56498686db35d5cbde5a8a/track-m...

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



@efialttes ,

That solution does not seem to meet any of my requirements, most notably:

The solution you recommend does not send a form with pre-populated and read-only information. I need the form to have read-only fields that are derived from an Excel sheet to give context to the audit. This will be a name or id number that will then be looked up elsewhere.

As the Excel sheet is already created, with a row for each response, there would be no Add a Row, but instead would only use Update a Row.

 

Unless I am reading it wrong. Can you please elaborate?

Hi again!

No, you are reading right, it was me that misunderstood your requirements.

So you are looking for a way to distribute a form, and some of the responses should be already filled in (and not editable by end user)...

I would discard Microsoft Forms and explore an alternate form interface based on a either PowerApps or Adaptive Cards

Nice challenge you got in mind... Happy Flowing!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

This does not seem, to me, to be a very complicated process, and I am disappointed in Microsoft in this MVP version of what, I hope, will be a far more robust Forms in soon-to-be-released updates.

I can access data in a form and dynamically apply that data elsewhere in the Flow, and quite easily. Similarly, in "Get a row," I can direct Flow to a table in an Excel sheet. However, astonishingly, after doing so, there is no way to access the data in the referenced table.

It boggles the mind.

I am very appreciative of your help. I have been banging my head against this for more days than I care to admit, refusing to believe the truth of this lack of functionality. Now, at least, I can give up on Forms and move on to a usefully robust application. 

Thank you for your help.

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (5,710)