cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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
Highlighted
Dual Super User III
Dual Super User III

Re: Accessing data in an Excel table

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
Highlighted
Dual Super User III
Dual Super User III

Re: Accessing data in an Excel table

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!



Highlighted
Frequent Visitor

Re: Accessing data in an Excel table

@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?

Highlighted
Dual Super User III
Dual Super User III

Re: Accessing data in an Excel table

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

Highlighted
Frequent Visitor

Re: Accessing data in an Excel table

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
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (7,373)