Input for ID in powerautomate flow

[Anonymous]

Hi guys, I realised this flow can only work if the ID is present in sharepoint list. Is there a value i can put for the id even when it doesnt exist in sharepoint list? Thank you. 

[v-dezhili-msft]

Hi @Anonymous ,

Unfortunately the get item action will only work if the id exists in the SharePoint table, if you enter a value that doesn't exist in the SharePoint table's id it will throw an error.

Best Regards,

Dezhi

[Anonymous]

Hi @v-dezhili-msft thank you. Can you help me with another question?

 Here is the if condition in my poweraitomate flow. For the box i highlighted in red, I want to use LoanEnd column from the excel so may i know how to modify the LoanStart to LoanEnd. Thank you.

[v-dezhili-msft]

Hi @Anonymous ,

Does the LoanEnd column already exist in the excel table? If you want to change the column name in the excel table in flow, it is impossible.

Best Regards,

Dezhi

[Anonymous]

Hello @v-dezhili-msft ,

yes LoanEnd column exists in the excel file

Here I want to put 2 conditions in this conditional statement

Just like below

so I want to use LoanEnd excel column in the red box as highlighted below. May I know how to execute this? Thank you.

[v-dezhili-msft]

Hi @Anonymous ,

What is stored in your LoanEnd column, and how do you make the condition action work?
The operation logic of the condition action in the picture you posted is that when the first two conditions are true and one or two conditions in "Or" are true, it will run if yes.

Best Regards,

Dezhi

[Anonymous]

Hi @v-dezhili-msft ,

I have a misconception of the conditional control. For my case, I want to create if condition for LoanStart 

and similar for LoanEnd but I dont know how to implement it.

My end goal is to check

if LoanEnd is null, no value will be inserted.

if LoanEnd is not null then

 (here chg to LoanEnd)

before i create the item  (next step of the flow)

May I know if you can assist me? Thank you so much.

[v-dezhili-msft]

Hi @Anonymous ,

Do you want to set the dateformat of LoanStart and LoanEnd only when they are both empty?
You can try:

Best Regards,

Dezhi

[Anonymous]

May I know how to change the LoanStart to LoanEnd?

I tried to insert

items('Apply_to_each')['LoanEnd'] in the expression

but the excel icon beside LoanEnd is not shown instead theres a variable icon. May I know what formula should I put to display LoanEnd with excel icon beside it ? Thank you.

[v-dezhili-msft · Accepted solution]

Hi @Anonymous ,

Is LoanEnd a column that already exists in your table?
Generally if the column already exists in your table you can select it in dynamic content.
Of course you can also use the items() formula to get it.

items('Apply_to_each')?['LoanEnd']

Best Regards,

Dezhi