How to get values of 1 row-Id when manually selected/created from a Excel table (or SharePoint list)?

[ahmadbutt]

I am trying to make a Flow that does the following:

- If 'Id' 10 is selected create a form(or file) that saves only the values of 'Id' 10. If 'Id' 100 than only the values of 'Id' 100 and so on... The 3th row got 3 columns instead of 4.

- Which triggers can I use for this? 

Is it possible to use the Excel file as source and make forms when a 'Id' is selected? Or does the Flow need to know if anything is created or modified? I also made a SharePoint list of the Excel file. If it is possible with the Excel file only than that is what I want to do. See the picture for the details.

[manuelstgomes]

Hi @ahmadbutt 

Yes, it's possible. Let's do it! 🙂

Before we start, the Excel connector doesn't have a "Created or Modified" trigger, so you have to do some extra work to find the information. If you can use a SharePoint list to store your data (not the file) this you,'ll save a lot of work since it does this for you. It's up to you, but since you asked for excel, let's take that path :).

First, the values where you're storing the information should be Excel tables. Make sure that they are otherwise Flow can't really fetch the information. 

After that, you need to run a Power Automation just once to add an id column to the table. Just create a Power Automation as follows:

OK, now we have or Excel formatted so that Power Automation can manage it better.

If you're always using these 3 columns then it's easy. Just create a Power Automation that triggers periodically (Schedule trigger) and check, using the ID column created before if the value in the column is 10 or 100. Something like this:

Now if you want to update data in the same excel, you need to do the same steps:

1. Ensure that the locations you want to update data are tables.

2. Add an ID column

Then you can update the values when you run the Power Automation.

All of this makes sense? It looks complicated but it isn't. If I missed something or if you don't understand some part of it, let me know, and we'll figure this out together :).

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[ahmadbutt]

@manuelstgomes thanks for you help. I don't understand how I can trigger a selected row to let Flow automatically do the other things? What do I need to do here?

[manuelstgomes]

HI @ahmadbutt 

Don't use that trigger. Use this one instead :).

Then you can create a recurrence to check the file..

Makes sense?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[ahmadbutt]

@manuelstgomes I just followed  the steps of the pictures u send me.. I get a error that I can't use this trigger, if I click on it?

[manuelstgomes]

hi @ahmadbutt 

Sorry I probably didn't explain correctly. Please remove the "manual trigger a flow" and replace it with the "Schedule"..

I'm sure this will work.

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up.

Cheers

Manuel

[ahmadbutt]

@manuelstgomes If I test the flow I don't get a error but the condition is not getting it correct?

----

[v-bacao-msft · Accepted solution]

Hi @ahmadbutt ,

You need to use the string() function to format the right parameter into string.

Best Regards,

[ahmadbutt]

@v-bacao-msft It works now. Is there a way to save the file as a Form instead of .txt? Or do I need to ask it in a new message?

[v-bacao-msft]

Hi @ahmadbutt ,

I'm afraid I don't know which file format Form refers to.

If you want the data to still be displayed in a table, then you can consider the following method.

Use HTML table action to format data and create a HTML file.

replace(body('Create_HTML_table'),'<table>','<table border="1">')

Take a try.

Best Regards,

[ahmadbutt]

@v-bacao-msft I can't use 'expression' in Compose, as you showed in your screenshot?

The whole Flow:

[v-bacao-msft]

Hi @ahmadbutt ,

Please set this to off.

Best Regards,

[ahmadbutt]

@v-bacao-msft I got it but I get also other things in the table?

[v-bacao-msft]

Hi @ahmadbutt ，

You can refer to the method mentioned in this thread to configure Value so that the table will only display the fields you need.

https://powerusers.microsoft.com/t5/Building-Flows/Extract-record-from-Excel-Onedrive-table-based-on...

Best Regards,

[ahmadbutt]

@v-bacao-msft It works now, thanks. So every time I want to select a Id-row I need so change this? Is there a easier way to do this for the end-user?

[v-bacao-msft]

Hi @ahmadbutt ,

Because you are entering the parameters manually, there doesn't seem to be an easier way.

You might consider storing the values in Compose first and then formatting the output of Compose so that you only need to change the Inputs.

Best Regards,

[ahmadbutt]

@v-bacao-msft If I select 10 it works, but if I select 100 or 1000 (the other 2 rows) than the condition gives a false instead of a true? If this works than I have everything I needed...

This is the problem I think, how to give the correct value so the Flow will work correctly?

[v-bacao-msft]

Hi @ahmadbutt ,

Is the key value manually or dynamically configured each time?

Based on your configuration now, this seems to be a fixed value.

You can configure the Dynamic content-Id-test output from Get a row in Compose's Inputs.

Please try again.

Best Regards,

[ahmadbutt]

@v-bacao-msft Uhm I don't understand how to do that.. Can you give me screenshots to understand how to get Dynamic content.

[v-bacao-msft]