cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ahmadbutt
Level: Powered On

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

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.nieuwewerkwijze.PNG

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

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

 

Hi @ahmadbutt ,

 

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

115.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Community Support Team
Community Support Team

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

 

Please tell me how you need users to enter Id-test, where to enter Id-test and trigger Flow.

 

If you use the Button as a trigger, you can add inputs to the button so that users can enter Id-test when triggering Flow.

132.PNG

 

 

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

22 REPLIES 22
Super User
Super User

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

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:

Screenshot_2019-12-06_at_09_42_31.jpg

 

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:

Screenshot_2019-12-06_at_09_48_32.jpg

 

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
Level: Powered On

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

@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?1e.PNG

Super User
Super User

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

HI @ahmadbutt 

 

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

small-Screenshot 2019-12-06 at 10.15.59.png

 

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
Level: Powered On

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

@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?a.PNG

 

Super User
Super User

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

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
Level: Powered On

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

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

----

2e.PNG

Community Support Team
Community Support Team

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

 

Hi @ahmadbutt ,

 

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

115.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

ahmadbutt
Level: Powered On

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

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

Community Support Team
Community Support Team

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

 

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.

116.PNG117.PNG

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

Take a try.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ahmadbutt
Level: Powered On

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

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

1e.PNG

The whole Flow:

2e.PNG

 

Community Support Team
Community Support Team

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

 

Hi @ahmadbutt ,

 

Please set this to off.

118.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ahmadbutt
Level: Powered On

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

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

1e.PNG

Community Support Team
Community Support Team

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

 

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ahmadbutt
Level: Powered On

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

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

1e.PNG

Community Support Team
Community Support Team

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

 

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.

119.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ahmadbutt
Level: Powered On

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

@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...1e.PNG

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

Community Support Team
Community Support Team

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

 

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ahmadbutt
Level: Powered On

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

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

Community Support Team
Community Support Team

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

 

120.PNG

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!

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!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,119)